SSMA v 9.0 - Data Migration at scale support
Published Jun 06 2022 12:35 PM 6,325 Views
Microsoft

We are happy to announce the release of SQL Server Migration Assistant (SSMA) v 9.0.  Data movement or data migration is key activity during the cutover. Organizations are looking for ways to reduce downtime and have a fail-safe scalable migration to Azure. With this release, we have revamped the current v8. * data migration experience and integrated with other Azure services and Azure data studio extensions (Database migration for Oracle)  to create a unified experience.

 

Overview

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

What's new?

The latest release of SSMA enhances the assessment and conversion capabilities of the tool with a targeted set of fixes designed to improve quality and conversion metrics. This release includes the following:

 

Data Migration at Scale

The new at scale data migration capability allows users to migrate data at source to Azure SQL target using Azure Data factory. This new offline data movement will allow end users to reduce the migration downtime by at least 2-4X compared to client-side and server side migrations.

  • A simple GUI workflow in SSMA to create end to end migration pipeline for migrating from data source to Azure SQL Target.
  • Ability to create new resource group, data factory etc. or re-use existing Azure resources for data movement directly from SSMA.
  • Ability to launch Azure portal and real time monitoring of the data factory pipeline execution.
  • Support for multi-tenant Azure active directory user.
    • Applies to SSMA for Sybase

Enhanced conversion capability for User Defined Datatypes in SSMA for Oracle

  • Previously, conversion of UDTs were limited for parameters within the scope of Oracle packages. Now, it has introduced support for UDTs at schema level (i.e. outside the declared package).
  • Conversion Support of Local declarations of UDTs.

Online help Integration:

  • Add support for online help and improvement of the F1 help experience.
    • Applies to SSMA for DB2, MySQL, Sybase, Oracle and Access

SSMA for DB2 Conversion enhancements:

  • Add support for exception Join
  • Add support for LISTAGG clause IN DB2 and conversion to STRINGAGG in SQL target
  • Improved support for trigger statements conversion in the case of DELETE and INSERT statements.

Downloads

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, Azure SQL Database managed instance, and  Azure SQL Data Warehouse (Azure Synapse Analytics)*.

* Azure Synapse Analytics is supported as a target only when using SSMA for Oracle.

 

Resources

SQL Server Migration Assistant documentation

Database Migration Assessment for Oracle 

Co-Authors
Version history
Last update:
‎Jun 06 2022 12:29 PM
Updated by: