Convert DB from MSSQL to MySQL

[DroppedAtBirth]

What is the best way to convert a MSSQL DB to a MySQL DB? Database consist of 61 table and 500,000+ records.

[Dan Morgan]

I cant comment on the best way, but have you heard of these guys.

http://www.realsoftstudio.com/

You can get a trial download and give it a whirl if its just one off.

[DroppedAtBirth]

I just found that about a minute before you posted.

I already tried using http://www.convert-in.com/ programs to convert to mssql -> access -> mysql

couldn't get half the table to even convert to access correctly.


I just downloaded Realsoftstudios software. Will try it.

[DroppedAtBirth]

Realsoftstudios software converter works great. I found a little bug in it but figured it out. Althought the trial version only converts up to 10 tables with 1000 records each - it is enought to see it works great.