Release: SQL Server Migration Assistant (SSMA) v8.2

[Jim Toland]

Overview

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).

What's new?

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.

Downloads

• SSMA for Access
• SSMA for DB2
• SSMA for MySQL
• SSMA for Oracle
• SSMA for SAP ASE

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.

Resources

• SQL Server Migration Assistant documentation

[Mahender_46]

Hi,

I have used this tool to migrate the 30 GB Database from Oracle to SQL. It took around 60 hours to complete. Data migration taking much time. Kindly fix the migration speed performance of SSMA tool for Oracle. For big databases this is not ideal tool. 

[Martin Kimzey]

Hello,

The Microsoft SQL Server Migration Assistant for Access v8.23 constantly crashes in the middle of the data transfer.  The resulting MS SQL Database is corrupt and unusable.  The application log shows:

Application: SSMAforAccess.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: exception code c0000005, exception address 7B78C0C5

Are there any alternative utilities to the SQL Server Migration Assistant for Access?