SSMA 7.0 Adds Support for Migrating to SQL Server 2016

Microsoft has released SQL Server Migration Assistant (SSMA) 7.0 which now supports migrating to SQL Server 2016 and has expanded support for Azure SQL Database.

All platforms:

• Support for SQL Server 2016
• Extended support for Azure SQL Database
• Support for running SSMA on Windows 10
• Fixed "save project" and "open project" commands for SSMA Console
• Fixed "securepassword" command for SSMA Console
• Fixed counting of objects for initial loading
• Removed installer check for .Net 2.0

Oracle

• Add conversion for in-memory tables and column store indexes to leverage In-Memory OLTP for SQL Server 2016 and In-Memory Columnstore for SQL Server 2016 and Azure SQL Database
• Added conversion of Oracle flashback archive tables to leverage SQL Server Temporal tables in SQL Server 2016 and Azure SQL Database
• Added conversion of Oracle VPD Policy converting to leverage Row Level Security in SQL Server 2016 and Azure SQL Database
• Decreased time of initial loading for Oracle
• Improved parser and resolver
• Updated Extension Pack dependency from .Net 3.5 to .Net 4.0

Db2

• Added conversion of DB2 in-memory tables and column store indexes to leverage In-memory OLTP for SQL Server 2016 and In-Memory Columnstore for SQL Server 2016 and Azure SQL Database
• Added conversion of DB2 access controls to leverage SQL Server Row Level Security for SQL Server 2016 and Azure SQL Database
• Added conversion of DB2 system-versioned tables to leverage SQL Server Temporal tables for SQL Server 2016 and Azure SQL Database
• Improved DB2 parser and resolver
• Removed unnecessary *.dll from Db2 installer

MySQL

• Improved parser and resolver
• Updated Extension Pack dependency from .Net 3.5 to .Net 4.0
• Fixed default BigInt typemapping for MySQL
• Fixed MsSql objects loading

MS Access

• Fixed tables data loading for UI tabs for Access
• Added support for disabling the loading of linked tables

Sybase ASE

• Updated Extension Pack dependency from .Net 3.5 to .Net 4.0

To download the SSMA 7.0 release see the following links:

• SSMA for MS Access
• SSMA for DB2
• SSMA for MySQL
• SSMA for Oracle
• SSMA for Sybase ASE

Comments

• Anonymous
  July 11, 2016
  Link to SSMA for MySQL links to MS Access instead.
  • Anonymous
    July 11, 2016
    Thanks for pointing this out. It has been corrected.
• Anonymous
  July 20, 2016
  What is the link to the forum form SSMA from MS Access? All I can find are forums with 2011 post dates.I want to learn if I can rename tables and fields during the conversion.
  • Anonymous
    July 21, 2016
    You can post on the SQL Server migration forum for this: https://social.msdn.microsoft.com/Forums/en-US/home?forum=sqlservermigration
    • Anonymous
      August 27, 2016
      Hello: We would like to migrate from an satndard SQL Server database to an Azure SQL Database, can you please post the link for SSMA for Azure SQL Database ?
      • Anonymous
        September 06, 2016
        SSMA supports both SQL Server and SQL DB migrations. When creating a new project, please select "SQL Azure" in the "Migrate to" field of the create project dialog.
• Anonymous
  August 17, 2016
  Link to SSMA for MS Access does not work. COuld you please fix it.
  • Anonymous
    September 06, 2016
    This appears to be resolved.ThanksLonny
• Anonymous
  September 01, 2016
  SSMA for Oracle is extremely slow. My case is Oracle 12c => Azure SQL Database. It was like takes a year to load objects. After that it takes unbelievable time just to convert objects. My database is 200 GB only, and when I convert the schema, I want to ignore index, trigger and packages which I don't need in Azure SQL Database. There's no option to rule them out even I don't need them. Seeking other methods for the migration.