Release: SQL Server Migration Assistant (SSMA) v7.7


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 is new?

  • Each iteration of the SSMA tool has been enhanced with targeted fixes that improve quality and conversion metrics.
  • SQL Server 2017 support is now official with the Oracle Extension Pack supported on Linux as well (new remote installation option).*
  • Based on the popular demand, we are bringing back the 32-bit version of the tool. Compared to the previous implementation (prior to v7.4), we now offer two installer packages, but they cannot be installed side-by-side. As a result, you must choose the most appropriate version based on the connectivity components you have. It is always preferable to use the 64-bit version if possible.
  • SSMA for MySQL now has ODBC Connection String connection mode, which allows you to use any third-party ODBC drivers that is compatible with MySQL.
  • SSMA for Oracle allows you to migrate Materialized Views as regular tables (configurable through the settings at Project Settings -> Synchronization -> Discover backing tables for Materialized Views).

* Extension Pack functionality is limited when installed on Linux, as the tester and server-side data migration features are not supported.

Note: With SSMA v7.4 and later versions, .Net 4.5.2 is an installation prerequisite.

Downloads

Supported source and target versions

Source: For supported sources, please review the information on the Download Center for each of the above SSMA v7.7 downloads.

Target: SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, Azure SQL Database, SQL Server 2017, and Azure SQL Data Warehouse**.

** Azure SQL Data Warehouse is supported as a target only when using SSMA for Oracle.

Resources

Comments (0)

Skip to main content