A new tool enables you to migrate from MySQL database to SQL Server. A community technology preview (CTP) of Microsoft SQL Server Migration Assistant (SSMA) for MySQL cuts the effort, cost and risk of migrating to SQL Server.

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.

SQL Server Migration Assistant for MySQL comes in two versions:

• For migrating from MySQL to SQL Server 2005
• For migrating to SQL Server 2008 and SQL Azure.

Requirements for the SSMA for MySQL client include:

• Microsoft Windows Installer 3.1 or a later version
• The Microsoft .NET Framework version 2.0 or a later version.
• MySQL Connector/ODBC v5.1.
• Access to and sufficient permissions on the computer that hosts the target instance of SQL Server 2005, SQL Server 2008 or SQL Azure database.
• 1 GB RAM

For more information, see blog posting Free Download: Microsoft SQL Server Migration Assistant. For a for free download and preview, see SSMA 2008 for MySQL v1.0 CTP1.

Bruce D. Kyle
ISV Architect Evangelist | Microsoft Corporation