Released: SQL Server Migration Assistant (SSMA) v7.1


Overview

SQL Server Migration Assistant (SSMA)  for Oracle, MySQL, SAP ASE (formerly SAP Sybase ASE), DB2 and Access lets users convert database schema to Microsoft SQL Server schema, upload the schema, and migrate data to the target SQL Server (see below for supported versions).

What is new?

  • SQL vNext on Windows and Linux CTP1 is now a supported target platform for migration. This feature is in technical preview and will allow schema and data movement to target SQL servers.
  • SSMA application now supports automatic updates to download the latest version of SSMA as soon as it is available.
  • SSMA installable binaries are now delivered through Windows installer package files (.msi).

 

Downloads

Supported sources and target versions

Source: For supported sources review the information on download center for each of the above SSMA v7.1 downloads
Target: SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL DB (Azure), SQLvNext CTP1 (Technical Preview)

Resources

Comments (2)

  1. Antony Batten says:

    It seems that SQL Agent is not supported on SQL vNext on Linux CTP1 ... therefore SSMA does not work because SQL Agent is a prerequisite. Is there a workaround?

    1. Sreraman says:

      You are right that SQL Agent is not yet enabled for SQL vNext on Linux. This means that users cannot do server side data migration. However, SSMA automatically defaults to client side data migration in this scenario which provides the users the same functionality.

Skip to main content