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.

Newsletters

You have been successfully signed up. To sign up for more newsletters or to manage your account, visit the Newsletter Subscription Center.
Subscription failed.
See All
See All