All things Data Related....

On this site I will be posting entries related to Data platform and analytics that I learn and believe could be valuable learning to others who want insight from their data

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

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

  • Comments 3
  • Likes

Microsoft announced today the release of the 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. 

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
Comments
  • Bonjour, j ai un probleme,quand j ouvre mon oidi ,j ai un message me disant que SQ  LIBRARY est mal installe ou corrompu que dois-je faire,merci,ladydy

  • Bonjour, j ai un probleme,quand j ouvre mon oidi ,j ai un message me disant que SQ  LIBRARY est mal installe ou corrompu que dois-je faire,merci,ladydy

  • thank you

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment