'

Microsoft delivers MySQL-to-SQL database migration tool

On August 12, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.

On August 12, Microsoft made available the first version of a tool designed to help customers migrate from MySQL to SQL Server and/or SQL Azure.

The MySQL migration tool is part of the SQL Server Migration Assistant (SSMA) tookit family. Version 1 is available for download from Microsoft's download center. Microsoft also refreshed its family of other SQL migration tools -- for Oracle, Sybase and Access -- at the same time as part of its 4.2 release yesterday. (The Access refresh also enables migrations to SQL Azure.)

Microsoft made available a first technology preview of the MySQL migration tool in January 2010.

As I noted back in January, even though MySQL has been a Microsoft partner, it also is a Microsoft competitor. And ever since Oracle bought Sun and (get MySQL in the process), Microsoft has been treating MySQL as even more of a rival.

SSMA for MySQL v1.0 works with MySQL 4.1 and above. The tool allows users to convert/migrate tables, views, stored procedures, stored functions, triggers, cursors, DML statements, control statements and transactions, according to a blog post on the SSMA Team's blog.