SQL to MySQL

[bungpeng]

May I know how to transfer my database from SQL Server to MySQL.

I did try use "Export data" feature in SQL 2000 to MySQL, but there is error to create table in MySQL... hope someone can help.... TQ

 

[Madz]

Importing Data from SQL to MySQL is a big problem. some time ago i have seen a Tool, i didnt remebered its name but its functionality was to transfer data from SQL Server to MySQL. i hope google.com might help you in this

 

[bungpeng]

It is a big problem? But I just remember last time I did before and it was quite easy....

Now I not sure whether it is because my SQL Server is version 7 at that time, so I think I need to test it in SQL Server 7.0.

You mean we need to use third party tool to transfer data between SQL Server and MySQL?

 

[jspencer]

Have a look at this website, theres some converters on it http://www.convert-in.com/mss2sql.htm (and theyre not too pricey either).

 

[jspencer]

I forgot to add, you wont get views or stored procedures from mssql into mysql though, and presumably no triggers either.
So if youre just trying to move tables and data, this should work a treat.

 

[bungpeng]

Thank you very much!

But for convert only 1 or 2 times, it is quite expensive....

 

[bungpeng]

I found a free MsSQL to MySQL converter
http://www.kofler.cc/mysql/mssql2mysql.html

Still testing on it...