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

问题:

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?

回答1:

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.

回答2:

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.