bungpeng Posted August 7, 2003 Posted August 7, 2003 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 Quote
Madz Posted August 9, 2003 Posted August 9, 2003 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 Quote The one and only Dr. Madz eee-m@il
bungpeng Posted August 11, 2003 Author Posted August 11, 2003 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? Quote
jspencer Posted August 11, 2003 Posted August 11, 2003 Have a look at this website, there's some converters on it http://www.convert-in.com/mss2sql.htm (and they're not too pricey either). Quote
jspencer Posted August 11, 2003 Posted August 11, 2003 I forgot to add, you won't get views or stored procedures from mssql into mysql though, and presumably no triggers either. So if you're just trying to move tables and data, this should work a treat. Quote
bungpeng Posted August 11, 2003 Author Posted August 11, 2003 Thank you very much! But for convert only 1 or 2 times, it is quite expensive....:) Quote
bungpeng Posted August 12, 2003 Author Posted August 12, 2003 I found a free MsSQL to MySQL converter http://www.kofler.cc/mysql/mssql2mysql.html Still testing on it... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.