Microsoft has made available the 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. 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.
Additionally, Microsoft has 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.)
Although 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.
Related Posts
Article by Muzzammil Waheed
Founder of BiGGTech.com, tech enthusiast, develops in Microsoft technologies with interests in technology, science and gadgets