Import data from Microsoft SQL (.MDF) file into My

2019-04-14 04:25发布

I am running PHP/5.3.0 with Apache/2.2.17 (Win32) in my Windows Vista PC. I have MySQL server version: 5.5.8. I have a Database.MDF file containing some tables. I want to import this data into my MySQL database. I have Microsoft SQL Server installed. I use PHP MyAdmin. Anybody got a solution or a software package?

2条回答
霸刀☆藐视天下
2楼-- · 2019-04-14 04:56

Have you checked this out? Importing data to MySQL from MS SQL

Or you can manually create the nysql tables, export the data from the MS into svg file and try importing it to mysql.

查看更多
在下西门庆
3楼-- · 2019-04-14 04:58

If you don't have MSSQL installed the simplest option would be to install SQL Server Express, attach your mdf, then export from there. You have quite a few options, from the simplest csv export/import, using a tool such as OpenDbCopy, or writing custom code to connect to both database and load from one to the other.

查看更多
登录 后发表回答