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.
The latest releases of SSMA enhances the assessment user experience by introducing summary charts in the reports. You can easily leverage conversions statistics to identify automatically converted objects and estimate the effort associated with manually converted objects. In addition, all tools improve messages navigation in assessment reports and allow to specify additional connection string options for target database connection.
Follow us on Data Exposed for dedicated episodes on SSMA newfeatures and subscribe to YouTube Channel: aka.ms/azuresqlyt to find out more on the next features.
In addition, this release includes the following:
SSMA for DB2 is enhanced with:
Fix AM/PM handling in ssma_db2.TIMESTAMP_FORMAT emulation function
Improve day-of-week validation in ssma_db2.TIMESTAMP_FORMAT emulation function
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.