SQL Server Migration Assistant (SSMA) Team's Blog

How-to articles, tips-and-tricks, and guidelines for migrating from Oracle/Sybase/MySQL/Access to SQL Server and SQL Azure

Microsoft announces SQL Server Migration Assistant for MySQL

Microsoft announces SQL Server Migration Assistant for MySQL

  • Comments 14

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

 

Microsoft announced today 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

 

  • I'm very impressed...  I stumbled across a link to this on eweek.com.  I want to congratulate the SQL team for being forethinking and realizing that making migration easier for administrators will result in a better market share, even against open source and free software - its not something you typically see out of Microsoft.  Just be sure to keep your tools up to date - as newer versions of the competitors software come out, you need to keep updating not reset on your past achievements, and keep the migration tools easy to use.

    Maybe they can show the other teams at Microsoft how to offer better support for migrating from competing products to Microsoft products (ie Groupwise 7 to Exchange 2010) or how about XPP to Win7 (damn Windows v2 user profiles).

  • I wonder how many system will migrate from MySQL (free) to a most expensive solution. Oracle database is another thing, but I have 16 year in the field and only know of one case... Anyway is good to have that tool.

  • Amazing.

    Who uses MySQL (free) now can use SQL Express (Free) and will be ready for big environments (like HA) when needs it.

  • the description done in Access table design viee does not come over when using SSMA tool.  is there a reason why?

  • As Mary Jo Foley recently reported migrating to SQL Azure just got a little easier with the latest version

  • Are there any tools available for migrating an SQL 7 db to the latest version of MS SQL?

  • Jonathan,

    You can upgrade your SQL7 db to SQL Server 2000 or 2005 and then do another upgrade to latest SQL Server 2008 R2. SQL Server setup program will handle the migration (=upgrade) automatically.

  • Is it possible to use SSMA to synchronize a master MySQL database with a slave SQL Server database on a periodic basis?  I.e., to establish the information schema between the two databases once, initially migrate all the data, and then repeatedly migrate the data from the Mysql database to the SQL Server database as the mysql data is changed to keep them synchronized, always in the same direction- mysql to sql server, (either on-demand or on a scheduled basis)?  If not, are there other tools that can do this?

  • If you are planning on a complete refresh, i.e. bringing in "all" the data from MySQL to SQL Server everytime, you can use the SSMA console application. You would need to create a script (samples get installed with the product) for this activity and launch SSMA console with that script to automate data migration.

    If you are asking for an incremental data replication, you can consider using SQL Server Integration Services (SSIS). You can write a SSIS package to transform the data and to fetch the data "incrementally".

  • For a fully automated tool to migrate and convert Access Applications to SQL Server, check out 2SQL from ConvertU2 Technologies http://www.convertu2.com.

    2SQL is an automated solution for the migration and conversion of Microsoft Access Applications to SQL Server.

    Convertu2 Technologies, recently nominated by Microsoft as  the only Partner  for “Migration and Conversion of Access applications to SQL Server”.. www.microsoft.com/.../migration.aspx

    There are millions of Access Applications in the field, these will be a bottleneck in moving to the cloud. 2SQL with its bulk processing capability can provide conversions to SQL Server is the first step in solving this problem..

    A version of 2SQL to convert to SQL Azure is about to be announced.

  • @Freddy

    When you consider the cost of maintaining a database with extra resources and development effort then I can see why people will move from mySQL to SQL Server. What's expensive is human resources not software. But if your system suits your needs don't change it!

  • It not working for last few days. While connecting to SQL Azure, I'm getting following error:

    This version of the SQL Server is not supported. You must connect to an instance of SQL Server 2008.

    It's seems microsoft has moved the database to R2, for which tool is not supported.

    Can some body suggest, how I can migrate MySql to Sql Azure.

    Thanks

    Rahul Kumar

  • @Rahul, can you elaborate on how you encouter your error?

  • Love Microsoft's free downloads, they never work! Honestly, Microsoft is the biggest argument for buying an Apple!

Page 1 of 1 (14 items)
Leave a Comment
  • Please add 4 and 7 and type the answer here:
  • Post