Microsoft Previews Tool to Ease Migration from MySQL to SQL Server

By Darryl K. Taft  |  Posted 2010-01-11

Microsoft has released a new preview version of a tool that enables users of the MySQL database to migrate to Microsoft's SQL Server.

On Jan. 11, Microsoft released a Community Technology Preview (CTP) of the Microsoft SQL Server Migration Assistant (SSMA) for MySQL, which the company refers to as "a toolkit that dramatically cuts the effort, cost and risk of migrating to SQL Server," in a blog post by Erika Sommer, a member of Microsoft's SQL Server marketing team.

The blog post goes on to say:

"A new addition to the SSMA family is the CTP version 1.0 for MySQL that provides an assessment of migration efforts as well as automates schema and data migration from MySQL to SQL Server. Freely download and preview this tool now."

The tool comes in two versions: One for migrating from MySQL to SQL Server 2005 and another for migrating to SQL Server 2008 and SQL Azure -- Microsoft's cloud-based relational database service built on SQL Server technologies.

The tool is supported on Windows 7; Windows Server 2003; Windows Server 2008; Windows Server 2008 R2; Windows Vista; Windows XP

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. The .NET Framework version 2.0 is available on the SQL Server 2008 product media. You can also obtain it from the .NET Framework Developer Center.

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


Rocket Fuel