We are delighted to announce the release of SQL Server Migration Assistant (SSMA) v9.3. We are thrilled to share that this latest version includes support for SQL Server 2022 as a target for all heterogenous migration scenarios.
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?
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:
SQL Server 2022 support
SQL Server 2022 has been officially certified and is now supported by SSMA. This means that our users can confidently migrate their databases to SQL Server 2022 with the assurance that SSMA has been fully tested and validated for compatibility with this latest version. We are excited to offer this new level of compatibility and support.
System Version table support in DB2
In this latest release, we are excited to announce an enhancement to the system version migration table support feature from DB2 to Azure SQL. The system version tables can now be converted into SQL compatible temporal tables, making it easier to manage and secure data. With these improvements, our customers can more effectively manage their data's history and evolution over time.
MySQL Support Improvement
Although SSMA for MySQL was previously not officially tested and supported for migrating from MySQL 8.X to Azure SQL, we are pleased to announce that in this release, it has been successfully tested and proven to be effective in this scenario.
Furthermore, we have increased the conversion coverage in this release by adding support for Common Table Expressions (CTEs), as well as enhanced support for datetime data types.
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, SQL 2022, Azure SQL Database, an Azure SQL Database managed instance, and Azure Synapse Analytics.
Resources
SQL Server Migration Assistant documentation