Automate database migration to Linux with the SQL Server Migration Assistant (SSMA)

Applies to: SQL Server (all supported versions) - Linux

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