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: