up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
90% accept rate
feedback

2 Answers

up vote 1 down vote

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

http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html

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.

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

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

http://opendbcopy.sourceforge.net/

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 :

link|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. – Solignis 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 : jtds.sourceforge.net , for mysql you can download : dev.mysql.com/downloads/connector/j/3.1.html – 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
feedback

Your Answer

 
or
required, but never shown
discard

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