SQL Server Migration Assistant (SSMA) v5.0

SQL Server Migration Assistant (SSMA) v5.0 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data migration as well as migration testing to reduce cost and reduce risk of your database migration project.

The new version of SSMA – version - is available with the following key enhancements:

  • Support for migration to SQL Server “Denali”
  • Multi-thread data migration for improved scale and performance.
  • Globalization support for migrating non-English databases to SQL Server.
  • Support for installation for SSMA Extension Pack on clustered SQL Server environments.
  • Sybase migration enhancement support:
    • Support for migration to SQL Azure
    • Extended data access connectivity to Sybase ASE ADO.NET and ASE ODBC providers
    • Support for proper conversion of case sensitive Sybase database to case sensitive SQL Server
    • Extended support for conversion of Non-ANSI joins for DELETE and UPDATE statements
    • Removed dependency on separate SYSDB database on target SQL Server
  • Report use of Oracle’s User Defined Type in the database object and inside PL/SQL.