Microsoft Previews Tool to Ease Migration from MySQL to SQL Server

 
 
By Darryl K. Taft  |  Posted 2010-01-11 Email Print this article Print
 
 
 
 
 
 
 

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

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.

 

 
 
 
 
Darryl K. Taft covers the development tools and developer-related issues beat from his office in Baltimore. He has more than 10 years of experience in the business and is always looking for the next scoop. Taft is a member of the Association for Computing Machinery (ACM) and was named 'one of the most active middleware reporters in the world' by The Middleware Co. He also has his own card in the 'Who's Who in Enterprise Java' deck.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Rocket Fuel