IT shops that are planning to move from MySQL to SQL Server 2005 and up will now have some help from Microsoft. The company recently made the first community technical preview (CTP) available for SQL Server Migration Assistant (SSMA) for MySQL v1.0.
The toolkit is designed to help simplify and automate the migration process to the latest versions of SQL Server, including the new SQL Azure Database service. Microsoft has released similar toolkits for organizations migrating off of Oracle, Sybase and Access databases, beginning with SSMA for Oracle in 2005.
Migrations from MySQL versions 4.1, 5.0 and 5.1 are supported by the toolkit. MySQL 5.1 is currently the most recent version of the database management system, released in April 2009. Users can use the toolkit to migrate databases to all versions of SQL Server 2008.
SQL Server Migration Assistant for MySQL v1.0 is expected to reach general availability this summer. Customers can download and preview the free CTP from the Microsoft website.