Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

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

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

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

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.

Resources

  • SQL Server Migration Assistant documentation
  • SQL Server Migration Assistant: How to assess and migrate database(s) from non-Microsoft data platforms to SQL Server
  • Extending SQL Server Migration Assistant’s conversion capabilities

Share the post

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

×

Subscribe to Msdn Blogs | Get The Latest Information, Insights, Announcements, And News From Microsoft Experts And Developers In The Msdn Blogs.

Get updates delivered right to your inbox!

Thank you for your subscription

×