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.
