Migration: SQL Server Migration Assistant 5.0 is released!

I am very pleased to see that version 5.0 of SQL Server Migration Assistant (SSMA) was released on April 28^th, 2011. This release will reduce the time to do a migration significantly. Some of the new features include:

• Reduced data migration time by SSMA exploiting multi-core processors and multiple-sockets.
• Globalization support for migrating non-English databases to SQL Server.
• Built-in support for clustered SQL Server environments in the SSMA Extension Pack.

If you are running your ISV offering on MySQL, Sybase or Oracle, you may wish to try a migration on a test system without any software costs. This is happening more and more often. Welly Lee, from the SSMA group, tells me that SSMA downloads are regularly exceeding 100K downloads/month.

• Download the free 180 Trial of SQL Server Enterprise Edition
• Download the appropriate SSMA below
• Try a DIY (Do It Yourself) migration of the data
  • With ISV Offerings, there is rarely a need to migrate any of the "As Installed" code, just move the data.
  • Any custom coding will need to be migrated. You will likely be surprised by how little manual conversion is needed.

Downloads are available below:

• SSMA for Oracle v5.0
• SSMA for Sybase v5.0
• SSMA for MySQL v5.0

For free SSMA product support just email ssmahelp@microsoft.com (they often respond in just a few hours).

Additional Resources:

• SSMA Team Blog: https://blogs.msdn.com/b/ssma 
• SQL Server Migrations Page: https://www.microsoft.com/sqlserver/en/us/product-info/migration.aspx
  • Step-by-step instructions for Oracle.
  • Step-by-step instructions for Sybase.
  • Step-by-step instructions for MySql.
• MSDN Forum: https://social.msdn.microsoft.com/Forums/en-US/sqlservermigration