Automate database migration to Linux with the SQL Server Migration Assistant

• 01/30/2018
• 2 minutes to read
• • 
  • 
  • 
  • 
  • 
  • +3

APPLIES TO: SQL Server (Linux only) Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel Data Warehouse

This article introduces SQL Server Migration Assistant (SSMA) that helps you easily migrate databases to SQL Server on Linux from Microsoft Access, DB2, MySQL, Oracle, and Sybase. SSMA is a Windows application, so use SSMA when you have a Windows machine that can connect to a remote SQL Server instance on Linux.

SSMA supports a variety of source databases including Oracle, MySQL, Sybase, DB2, and Microsoft Access to SQL Server on Linux and helps automate migration tasks such as:

• Assess your source database
• Convert the source database schema to Microsoft SQL Server schema
• Migrate the schema
• Migrate the data
• Test the migration

To get started, download SQL Server Migration Assistant (SSMA) for your source database from the following list:

• SSMA for Access
• SSMA for DB2
• SSMA for MySql 
• SSMA for Oracle
• SSMA for Sybase ASE

Next, follow the SQL Server Migration Assistant (SSMA) to migrate your source database to SQL Server on Linux.

See also

• Microsoft Data Migration blog
• SQL Server Migration Assistant (SSMA) blog