SQL Server Migration Assistant (SSMA) for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2, and Access allows users to convert a database schema to a Microsoft SQL Server schema, upload the schema, and then migrate data to the target SQL Server (see below for supported versions).
The latest release of SSMA enhances each “flavor” of the tool with a targeted set of fixes designed to improve quality and conversion metrics, as well as fixes for:
- An issue with disabled non-clustered indexes after data migration.
- Detection of .NET Framework during silent installation.
- An intermittent crash that occurs when a new version is downloaded.
In addition, this release includes the following:
- SSMA for Access has been enhanced to gracefully handle invalid dates during data migration.
- SSMA for DB2 has been enhanced to fix issues with:
- Connection to Azure SQL Database from the SSMA console tool.
- Missing COUNT_BIG column in views declaration during conversion.
- SSMA for Oracle has been enhanced to:
- Add support for DBMS_OUTPUT.ENABLE/DISABLE.
- Remove CAST AS FLOAT for BINARY_FLOAT and BINARY_DOUBLE columns in default data migration query.
- Fix sequences refresh if the current value has changed.
- Fix bug related to misinterpretation of pseudo-columns (ROWNUM, etc.) if a column with the same name exists.
- Fix a crash that occurs converting FOR loops with ambiguous unresolved identifier.
IMPORTANT: A known issue with auto-update may cause the failure of an update from SSMA v8.1 to v8.2. If you encounter this error, please download and install the new version manually.
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 SQL Data Warehouse is supported as a target only when using SSMA for Oracle.