Geek Answers Handbook

Import data from a Microsoft SQL file (.MDF) into MySQL

I am running PHP/5.3.0from Apache/2.2.17 (Win32)on my Windows Vista PC. I have a 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 am using PHP MyAdmin. Has anyone got a solution or software package?

+2
source share
2 answers

If you do not have MSSQL installed, the easiest option is to install SQL Server Express , attach your mdf, then export from there. You have quite a few options, from the simplest export / import of csv, using a tool such as OpenDbCopy , or write your own code to connect to both the database and the load from one to the other.

+2
source

Have you checked this? Import data into MySQL from MS SQL

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

0
source

More articles:


All Articles