SQL Server Migration Assistant (SSMA) Access, DB2, MySQL, Oracle, and SAP ASE (formerly SAP Sybase ASE) 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).
In addition to a targeted set of fixes designed to improve usability and performance, the latest release of SSMA enhances each “flavor” of the tool by adding a setting that enables users to omit SSMA extended properties in the converted code.
To leverage this setting, in SSMA, navigate to Tools > Project Settings > General > Conversion, and then under Misc, set the value of the Omit Extended Properties setting to Yes.
Important: SSMA v8.5 and later have been updated to require .NET Framework version 4.7.2. If you don’t already have this version installed, download and install the runtime file from here.
In addition, this release includes the following enhancements:
SSMA for DB2 now provides:
A fix for conversion of functions that use default argument values
Improved parsing of functions in the PARAMETER clause.
The ability to convert the LEAVE statement.
SSMA for Oracle now provides improved parsing of the XMLTABLE clause.