snippetsqlMinor
How to migrate SQL Server to MySQL
Viewed 0 times
sqlmigratemysqlhowserver
Problem
I'm trying to migrate a SQL Server db to MySQL, and I'm having a tough time. I've tried:
-
MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables themselves, and so I can't get past the "Schemata Selection" screen.
-
sqlcmd and bcp -- both fail because they can't export csv properly. They don't quote strings with commas in them. Plus, they don't create table schemas in MySQL.
-
SQLyog -- just fails. Creates a MySQL table from a MS SQL view ok, but doesn't import the data. Also takes a really long time on small tables, and I have to import millions of rows.
Anyone have suggestions?
-
MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables themselves, and so I can't get past the "Schemata Selection" screen.
-
sqlcmd and bcp -- both fail because they can't export csv properly. They don't quote strings with commas in them. Plus, they don't create table schemas in MySQL.
-
SQLyog -- just fails. Creates a MySQL table from a MS SQL view ok, but doesn't import the data. Also takes a really long time on small tables, and I have to import millions of rows.
Anyone have suggestions?
Solution
If you want to quickly migrate your data from MS SQL Server to MySQL, I suggest using the Migration tool from Oracle. This can really save you some time and effort.
This article can help you get started:
http://www.infoq.com/news/2012/08/MySQL-Migration
This article can help you get started:
http://www.infoq.com/news/2012/08/MySQL-Migration
Context
StackExchange Database Administrators Q#38863, answer score: 3
Revisions (0)
No revisions yet.