When I have had to move data from Microsoft SQL Server to MySQL I have used MySQL Workbench data migration wizard – well, presumably used, as there has never been enough time to document the process. But as I spent several hours today trying to re-build the setup and ended using RazorSQL (during last 15 minutes)… some notes for future me googling the same problem.
- MySQL Workbench requires ODBC for connecting to MS SQL, easiest solution on OSX seems to be OpenLink’s ODBC driver which has 2×14 day trial license (simple installation and configuration).
- BUT apparently MySQL Workbench requires “View Any Definition” rights from db user, missing from hosted solution I had to access. There is a bug report describing the problem and a tutorial video explaining minimal rights, but in my case neither helped.
- BTW, Oracle user registration – required to comment on bug – seems to be the worst signup I have ever met, doing crazy stuff like replacing repeat password field contents with ***** (yes, 5 asterisks) after moving to next field and unable to accept auto-fill data. (While looking for solution I also started downloading Microsoft SQL Server Express – and had another unforgettable experience being told on Microsoft ID registration that my password is too long, max being 16 chars…).
And with RazorSQL?
- download trial
- use bundled JDBC connector
- create connection
- select DBO
- DB Tools -> Database Conversion -> Convert multiple tables
Resulting SQL was pretty importable using PHPMyAdmin – with the exception of some blob fields that had been marked “not null” for no good reason in MS SQL… And need to import data first and then enforce costraints.