moving data from MS SQL to MySQL, on OSX

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.

Postitatud rubriiki ms sql, mysql. Talleta püsiviide. Kommenteerimine ja trackback-viidete lisamine ei ole lubatud.