[Find below the text of the September 2012 e-newsletter sent out to PL/SQL Challenge subscribers.]
Another summer gone...and a hot one it was. Let's just hope the ice in the
Arctic circle returns next year. In the meantime, eyes turn towards Oracle Open
World, the annual extravaganza of All Things Oracle (and that is an
awful lot of "things", compared to the old days).
As many already know, I’ve been trying to get the MySQL Workbench migration feature working between Microsoft SQL Server 2012 and MySQL 5.5. There are a number of features added to the point release, and one led me to believe that the Migration tool expects to find the data in a schema of its own, as opposed to the
dbo schema. Having made that change in Microsoft SQL Server, it did appear to have a positive impact on the migration.
Getting the MySQL Workbench’s Database Migration has been interesting, and at present incomplete. While I can now successfully connect to the SQL Server 2012 source database and capture a schemata list, migrating the data from SQL Server doesn’t work. Actually, the connection doesn’t work without modifying a Python library in the current MySQL Workbench release.