Some interesting new from Microsoft, for those that wish to migrate from MySQL to SQL Server:

Microsoft recently announced the first CTP of a SQL Server Migration Assistant (SSMA) for MySQL v1.0, which automates aspects of the migration process to Microsoft SQL Server 2005 & 2008 including SQL Azure Database.

SQL Server Migration Assistant for MySQL is the newest migration toolkit, others include Oracle, Sybase, Access, and an analyzer for PowerBuilder. The toolkits were designed to tackle the complex manual process customers deal with when migrating databases. In using the SQL Server Migration Assistants, customers and partners reduce the manual effort; as a result the time, cost and risks associated with migrating are significantly reduced.  Our recent SSMA survey showed that 94% of SSMA downloaders would recommend the tool to others.

Since the SQL Server Migration Assistants for Oracle became available in June of 2005, Microsoft has seen more than a 250,000 downloads across all of the SSMAs.  Motorola, Simon & Schuster, Sony Ericsson and Artesia are just a few of the customers that have downloaded and used the SQL Server Migration Assistant toolkit to move to Microsoft SQL Server.

SQL Server Migration Assistant for MySQL v1.0 will be generally available in the summer of 2010 as a free toolkit. The CTP is available today for download and preview at SSMA 2008 for MySQL v1.0 CTP1. Customers and partners can also provide feedback to: ssmateam@microsoft.com.

More information can be found at the DPI blog.