Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am looking for a way to export data from our PRODUCTION SQL Server 2000 so I can import it into a MySQL server I setup for testing.

I tried having the server generate an SQL script from the enterprise manager, but it is not understood by MySQL. Upon looking to the script with Notepad++ I noticed that it is setup for being loaded into another MSSQL server.

Any ideas on how to make a generic SQL dump that MySQL can understand.

Also I need the data to left on the other server untouched I just need a copy of it.

share|improve this question

There is not simplified portability between these database platforms; With an understanding of the link and a combination of tools it can be done;

Make sure to always keep an up to date backup of your database before trying anything. good luck, let me know if you have any questions.

share|improve this answer
Many thanks, I will let you know. – ianc1215 Dec 2 '10 at 21:22
If use MS DTS export that data from the server will it leave the original intact? – ianc1215 Dec 2 '10 at 21:41

You could try with a tool like OpenDBCopy that is an opensource database migration tool :

With opendbcopy you can migrate from and to several database type, all that have an avalaible JDBC driver.

I've used this tool often in migration and it's a good database migration tool.

Is written in java and work both linux and windows OS.

There's also many commercial alternatives to openDbCopy(that are simplier) like :

share|improve this answer
It did not work for me, I had java problems and then after java started working it complained about not being able to see the server. – ianc1215 Dec 3 '10 at 1:46
you need to download the appropriate JDBC Driver and put it into lib dir, for Microsoft SQL you can Download JTDS driver : , for mysql you can download : – aleroot Dec 3 '10 at 7:07
openDBCopy doesn't seem to have been updated since '04. It makes me wonder how reliable it is since it doesn't appear to be maintained any further. – MacAnthony Jan 31 '11 at 16:19
I had the same problem and decided to try openDBcopy. And, what do you know, it works with some minor config changes. I put it on github at – MikeHoss Jun 3 '15 at 23:29

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.