Announcing SQL Server Migration Assistant (SSMA) v.5.1

  • Article

Automating database migration from Oracle, Sybase, MySQL, and Access database to SQL Azure and SQL Server “Denali”.

Microsoft announced today the release of SQL Server Migration Assistant (SSMA) v.5.1, a family of products to automate database migration to all edition of SQL Server (including SQL Server Express) and SQL Azure.

What’s New in this Release?

SSMA v5.1. supports conversion to the new features in SQL Server “Denali”, including:

Free Downloads:

SSMA v5.1 is available for FREE and can be downloaded from the following:

Customers and partners can provide feedback or receive FREE SSMA technical support from Microsoft Customer Service and Support (CSS) through email at ssmahelp@microsoft.com.

Resources:

For more information and video demonstration of SSMA and how it can help with your database migration, please visit:

Comments

  • Anonymous
    July 30, 2011
    IBM DB2 to SQL ?

  • Anonymous
    December 06, 2011
    Can you fix the Oracle utilities in SSMA so it can install against a Case Sensitive database?

  • Anonymous
    December 15, 2011
    Peter, thanks for your feedback. Do you mean Oracle extension package? We'll consider fixing it in new versions.

  • Anonymous
    December 21, 2011
    Actually - correct me if I'm wrong - SQL Server 2008 Express edition doesn't have the Agent (at least, you cannot run it) preventing the use of SSMA to this type of installation. Can you confirm? See for instance social.msdn.microsoft.com/.../4df978b6-077b-4556-b52d-8ceca3a397ab

  • Anonymous
    December 27, 2011
    SQL Agent is for server-side data migration. SSMA also supports client-side data migration. So it won't prevent you from migrating to express edition.

  • Anonymous
    March 26, 2012
    I have been trying to migrate a 180gb database, and it works great except on tables > 10million rows ... the record counts are correct, the SSMA looks like it is migrating ok (######## of ######### rows processed) however when it comes to the end of the count, no records are migrated and the SSMA error log shows "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding".  My migration is from Oracle 10.2.0.4.0 10g AIX/64 bit to SQL Server 2008 R2.  I can find no place or instruction on adjusting timeout.  I'm guessing that becasue the sql server side is processing data, the oracle side has gone idle and when sql communicates back it fails.  

  • Anonymous
    August 16, 2012
    TJ, same here. That error is from SQL server side. Have you found out solution?

  • Anonymous
    August 20, 2012
    Hi - I'm a PM on the SSMA team. I got this information from one of our devs. "The error is coming from the SQL Server side, i.e. for a command running on SQL Server, not on Oracle. There are two possible sources for it – SqlBulkCopy (i.e. timeout when writing the data) and SqlClient (i.e. timeout when reading/writing some internal status info). There is “Data migration timeout” option in “Project settings”->”General”->”Migration”, but it is 15 minutes per batch (by default) so should not be the root cause. Actually, we need a log file (with the debug level info) in order to properly investigate this issue, however user might try the following workarounds: • Apply support.microsoft.com/.../913177. If installation fails saying “The upgrade patch cannot be installed by the Windows Installer Service because the program to be upgraded may be missing or the upgrade patch may be update a different version of the program...", try steps below. • In “Project settings”->”General”->”Migration”, switch “Parallel data migration mode” option to “Custom” and “Thread Count” to 1. • In “Project settings”->”General”->”Migration”, set “Batch Size” to a lower value, e.g. 1000." If that fails contact ssmahelp@microsoft.com with the log file. I hope that helps. -Sam

  • Anonymous
    November 05, 2012
    Hi Jim, I just installed the latest SSMA v5.2 Oracle extension back and I'm still getting errors during installation. Have you had a chance to fix the installer to run against a case sensitive database? By default, Oracle treats the data as case sensitive and the metadata as case insensitive. With SQL Server, when we want to get the same behavior (ie treating the data as case sensitive), SQL Server also treats the metadata as case sensitive. Thanks, -Peter

  • Anonymous
    December 17, 2012
    I have the same timeout errors when migrating Oracle tables with a few millinon of recods in them. I would like to try the workouround, but before installing it, would it be possible to know what it does? Thanks Igor

  • Anonymous
    November 05, 2013
    Hi , I am also facing the same issue. Is there any update or workaround for this issue?

  • Anonymous
    April 30, 2014
    Hi, has anyone found out the fix for timeout?

  • Anonymous
    April 30, 2014
    I have both the workaround mentioned above in Sam's comment with no luck.

  • Anonymous
    February 26, 2015
    I have the same issue as TJ and J2 above.  I am able to migrate smaller oracle tables just fine.  But when I go above the 20 million row tables and up I get the following error:      "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding." I am on: Windows Server 2008 R2 SQL Server 2008 R2 Oracle 9i on AIX 5L 64 bit SSMA 5.3 Thanks in advance for any comments.

    • Anonymous
      May 24, 2016
      The comment has been removed