First published on MSDN on Feb 17, 2019
Authored by datamigrationteam@microsoft.com
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, deploy the schema, and then migrate data to the target SQL Server (see below for supported versions).
What's new?
Each iteration of the SSMA tool has been enhanced with targeted fixes that improve quality and conversion metrics. In addition, this release offers the following new features:
- Support Azure SQL Database Managed Instance as a target. You can now create new projects targeting Azure SQL Database Managed Instance:
Note : The SSMA for Oracle Extension Pack was also updated to allow remote installations on Azure SQL Database Managed Instance:
Some features, including Tester and Server-side data migration, are not supported when targeting Azure SQL Database Managed Instance. Read more here.
- Post-conversion Fix advisor . Learn more about it here.
- Preliminary database/schema selection.
When connecting to source user is now able to select databases/schemas of interest. Selecting only the schemas you plan to migrate will save time during initial connection and improve overall SSMA performance.
Finally, SSMA for Oracle has been enhanced to:
- Use the official managed NET driver to connect to Oracle. The OCI driver is no longer a prerequisite for using SQL Server Migration Assistant for Oracle.
- Map ROWID and UROWID to VARCHAR by default. Changed from ‘uniqueidentifier’ to accommodate data migration for explicit ROWID columns.
Downloads
Supported source 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, 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.
Resource