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

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.

Up vote 0 down vote favorite share g+ share fb share tw.

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? Thanks in advance... :) mysql sql sql-server database import link|improve this question edited Jan 4 at 11:12 asked Dec 4 '11 at 17:44blasteralfred1,075431 95% accept rate.

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.

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.

Try with a converter tool like openDbCopy or ESF Data Migration Toolkit.

Not working.. it is asking for sql password. I don't have sql server. Question revised.

– blasteralfred Dec 5 '11 at 7:38.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.