Overview

SQL Server Migration Assistant (SSMA) Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE) allow users to convert a database schema to a Microsoft SQL Server schema, deploy the schema, and then migrate data to the target SQL Server (see below for supported versions).

What’s new?

Enhanced monitoring experience for migrations using DMS [ SSMA-Oracle]

 Migrating Oracle workloads using Azure Database Migration service is in preview, please refer for more details.

For Oracle workloads migrating using DMS in SSMA, we are bringing an enhanced monitoring experience through tabular user interface where the users can now view live list of migrations that are in progress or completed phase. Each entry represents a migration activity along with the start time of migration, DMS used for migration and status.

Users can view quick brief migration information of individual tables to know more information like Table name, Schema name, copy duration, No. of Rows copied & status real-time.

For the sake of users requiring more granular monitoring information about their migration activity, SSMA provides a link to the Azure Database Migration service portal webpage (View Comprehensive Report) where they can view details like Data read, writes, Rows copies, Throughput along with copy duration, etc.

Code Conversion Improvements [DB2, Oracle]

• Conversion enhancements for identity column from Db2 z/OS to SQL Server 2019
• Improve conversion of Db2 stored procedure WITH RETURN clause to Azure SQL Database
• Improve database objects load for Db2
• Appropriate error handling for conversion of identifier REPLACE(STRING, CHAR,CHAR) in Db2
• Detection of CHAR length in Oracle VARCHAR2 datatype

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 2016, SQL Server 2017, SQL Server 2019, Azure SQL Database, an Azure SQL Database managed instance

Resources

SQL Server Migration Assistant documentation