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