How to migrate SQL Server database to MySQL?

mysql sql-server database-migration
Mark Ma picture Mark Ma · Nov 5, 2011 · Viewed 84.2k times · Source

I have a SQL Server database with lots of data and an empty MySQL database. Now I want to copy all data of SQL Server database (including the database schema) to the MySQL database.

I thought about using raw SQL dump, but SQL Server's SQL syntax is not same as MySQL.

And I have googled some database migration tool, such as south (only for django), simple-db-migration (only for one type of database, maybe PostreSQL?) and SQLAlchemy (I haven't finished learning it, just feeling it somewhat clunky).

What tool can I use to do this migration?

Answer

aleroot picture aleroot · Nov 5, 2011

I'm usually using opendbcopy for these kind of jobs ...

Related questions

How to export SQL Server database to MySQL?

I'm trying to convert from a SQL Server database backup file (.bak) to MySQL. This question and answers have been very useful, and I have successfully imported the database, but am now stuck on exporting to MySQL. The MySQL Migration …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) values: id | item | price ------------- 10 | book | 20 20 | book | 30 Now I want to: update table1 set table1.Price = table2.price where table1.…

Read More