Microsoft delivers MySQL-to-SQL database migration tool

Summary: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.

Topics: Open Source, Data Centers, Data Management, Enterprise Software, Microsoft, Software, Software Development

About

Mary Jo Foley has covered the tech industry for 30 years for a variety of publications, including ZDNet, eWeek and Baseline. She is the author of Microsoft 2.0: How Microsoft plans to stay relevant in the post-Gates era (John Wiley & Sons, 2008). She also is the cohost of the "Windows Weekly" podcast on the TWiT network. Got a tip? Se... Full Bio

Contact Disclosure

Kick off your day with ZDNet's daily email newsletter. It's the freshest tech news and opinion, served hot. Get it.

Related Stories

The best of ZDNet, delivered

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