Microsoft announces SQL Server Migration Assistant for MySQL

Migrate from MySQL to SQL Azure or SQL Server with ease!

Microsoft announced the release of first version of SQL Server Migration Assistant (SSMA) for MySQL! Along with this release, Microsoft refreshed the existing SSMA family of products for Oracle, Sybase and Access with the latest v4.2 release.

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 customer’s deal with when migrating databases. In using the SQL Server Migration Assistants, customers and partners reduce the manual effort; as a result the time, cost and risks associated with migrating are significantly reduced. Our recent SSMA survey showed that 94% of SSMA downloader’s would recommend the tool to others. All SSMA toolkits are available for free download.

Since the SQL Server Migration Assistants for Oracle became available in June of 2005, Microsoft has seen more than a 250,000 downloads across all of the SSMAs. US Department of Defense, Aon, AIM Healthcare, Motorola, Simon & Schuster, Sony Ericsson and Artesia are just a few of the customers that have downloaded and used the SQL Server Migration Assistant toolkit to migrate to Microsoft SQL Server.

With this wave of release, customers can migrate to any edition of SQL Server 2008 R2, SQL Server 2008 or SQL Server 2005. Brand NEW with this release, SSMA for MySQL and SSMA for Access products also support simple and direct migration to SQL Azure.

The latest SQL Server Migration Assistant is available for free download and preview at:
1. SSMA for MySQL v1.0, out of the two downloads, ‘SSMA 2008 for MySQL’ enables migration to SQL Azure
2. SSMA for Access v4.2 out of the two downloads, ‘SSMA 2008 for Access’ enables migration to SQL Azure
3. SSMA for Oracle v4.2
4. SSMA for Sybase v4.2
Customers and partners can provide feedback via ssmateam@microsoft.com.

SSMA for MySQL v1.0 is designed to work with MySQL 4.1 and above. Some of the salient features included in this release are the ability to convert/migrate:
• Tables
• Views
• Stored procedures
• Stored functions
• Triggers
• Cursors
• DML statements
• Control statements
• Transactions

The latest SSMA v4.2 release for Oracle/Sybase/Access includes:
• Console support for automated DB assessment/DB migration/SQL syntax conversion for application migration.
• Support for client side and server side data migration for convenience.
• Better support for 64-bit platform.
• Microsoft Access (Access 97 and above) to SQL Azure migration (you can continue to use existing Access front end applications though the data resides in SQL Azure)
• Support for migrating to SQL Server 2008 R2
• Support for migrating from latest Oracle (11g R2), Sybase (15.5) and Access (2010) releases

SSMA for MySQL v1.0 CTP released

SQL Server Migration Assistant for MySQL is newest member of SSMA family!

Microsoft SQL Server Migration Assistant (SSMA) 2008 is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2008 and SQL Azure. SSMA 2008 for MySQL v1.0 CTP1 provides an assessment of migration efforts as well as automates schema and data migration. It is first member of SSMA product family which includes support for SQL Azure.

SSMA 2008 for MySQL v1.0 CTP1 is designed to work with MySQL 4.1, 5.0 and 5.1 and all editions of SQL Server 2008 or SQL Azure.
You can download the tool from the links below.

SSMA 2008 for MySQL v1.0 CTP1

SSMA 2005 for MySQL v1.0 CTP1

Migration to SQL Server

Are you planning to move your database from Oracle, Sybase and Access to SQL Server?
Do you need assistance and guidance on the migration?

Microsoft provides SQL Server Migration Assistants for Oracle, Sybase and Access is a complete suite of tools which cuts the effort, cost and risk of migration to SQL Server.

Microsoft has also created Migration Solutions Center which consists of whitepapers , prescriptive guidance and other resources to assist you with your migration.

SQL Server 2008 Migration Assistants Downloads
SSMA 2008 for Oracle
SSMA 2008 for Oracle automates the end to end database migration process from Oracle to SQL Server 2008. It performs assessment, schema migration, data migration and validation of migrated database objects.


SSMA 2008 for Sybase ASE
SSMA 2008 for Oracle automates the database migration process from Sybase ASE to SQL Server 2008. It performs assessment, schema migration, data migration and validation of migrated database objects.


SSMA 2008 for Access
SSMA 2008 for Oracle automates the database migration process from Access to SQL Server 2008. It converts Access database objects to SQL Server database objects and performs the data migration. It supports Access 97 - Access 2007 databases.

SSMA 2008 for Sybase PowerBuilder Applications
SSMA 2008 for Sybase PowerBuilder Applications is a tool that cuts the effort, cost, and risk of migrating PowerBuilder Applications designed for Sybase ASE to SQL Server 2008.

SQL Server 2005 Migration Assistants Downloads
SSMA 2005 for Oracle
SSMA 2005 for Oracle automates the database migration process from Oracle to SQL Server 2005.

SSMA 2005 for Sybase ASE
SSMA 2005 for Sybase ASE automates the database migration process from Sybase ASE to SQL Server 2005.

SSMA 2005 for Access
SSMA 2005 for Access automates the database migration process from Access to SQL Server 2005.

Migration Whitepapers
Guide to Migrating from Oracle to SQL Server 2005 using SSMA

Guide to Migrating from Sybase ASE to SQL Server 2005 using SSMA

Migrating from MySQL to SQL Server 2005

DB2 to SQL Server Migration Guide

The intent of this blog is to help you in using SSMA tools for database migration and sharing knowledge,expertise and best practices from migration community.