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

Question

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?

Have you looked at some of the related questions? --> --> --> — Stephen Turner
– Stephen Turner, Commented Dec 4, 2011 at 17:48

Cruachan · Accepted Answer · 2011-12-05 08:56:05Z

2

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.

answered Dec 5, 2011 at 8:56

Cruachan

16.1k6 gold badges63 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:59:40Z

0

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.

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Dec 4, 2011 at 17:47

greenLizard

2,3465 gold badges24 silver badges31 bronze badges

Collectives™ on Stack Overflow

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

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related