Release: SQL Server Migration Assistant (SSMA) v8.19

This article is contributed. See the original author and article here.

Overview

SQL Server Migration Assistant (SSMA) is a suite of 5 tools designed to automate migrations from Oracle, Access, DB2, MySQL and SAP ASE (formerly SAP Sybase ASE) to Microsoft SQL. It automates the conversion of database schemas to a Microsoft SQL Server schemas, deployment of  the schemas, data migration to the target SQL Server (see below for supported versions), and validation of migrated objects.

 

 

What’s new?

The latest releases of SSMA for Oracle and SSMA for Sybase enable validation of converted database objects and transferred data to Azure SQL Database, Azure SQL Managed Instance and Azure Synapse SQL Pools. Storing and running the test cases on the client-side has streamlined the setup process and removed the extension pack requirement. Moreover, you can now easily share test cases between SSMA projects by copying the ‘tester’ folder.

 

In addition, this release includes the following:

    

• SSMA for MySQL and SSMA for Access surface minor performance improvements and bug fixes

• SSMA for DB2 is enhanced with:




• Improved TIMESTAMP_FORMAT emulation function


• Improved foreign keys discovery for z/OS platform

• SSMA for Oracle addresses the following: 
  
  
  
  • Improved resolution logic in SELECT list when user-defined column names match system functions
  
  
  • Ignore system-defined columns (SYS_STS*) and indexes (SYS_IL*)
  
  
  • Fixed issue with packages disappearing from the objects tree after reconnect to Oracle database
  
  
  • Fixed CLR assemblies deployment issue on Azure SQL Database in 32-bit SSMA package
  
  
  
  

 

Downloads

• SSMA for Access


• SSMA for DB2


• SSMA for MySQL


• SSMA for Oracle


• SSMA for SAP ASE

 

Supported sources and target versions

Source: For the list of supported sources, please review the information on the Download Center for each of the above SQL Server Migration Assistant downloads.

Target: SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, an Azure SQL Database managed instance, and  Azure SQL Data Warehouse (Azure Synapse Analytics)*.

*Azure SQL Data Warehouse (Azure Synapse SQL Pool) is supported as a target only when using SSMA for Oracle.

 

Resources

SQL Server Migration Assistant documentation

Testing Migrated Database Objects (OracleToSQL)

Testing Migrated Database Objects (SybaseToSQL)

Brought to you by Dr. Ware, Microsoft Office 365 Silver Partner, Charleston SC.