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
- SSMA for Access
- SSMA for DB2
- SSMA for MySQL
- SSMA for Oracle
- SSMA for SAP ASE (formerly SAP Sybase ASE)
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)
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?
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.