Services and tools available for data migration scenarios

This article provides a matrix of the Azure and third-party services and tools available to assist you with various database and data migration scenarios and specialty tasks.

The following tables identify the services and tools you can use to plan for data migration and complete its various phases successfully.

Note

In the following tables, items marked with an asterisk (*) represent third-party tools.

Pre-migration phase

Source Target App Data Access
Layer Assessment
Database
Assessment
Performance
Assessment
SQL Server Azure SQL DB DAMT / DMA DMA
Cloud Atlas*
Cloudamize*
DEA
Cloudamize*
SQL Server Azure SQL MI DAMT / DMA DMA
Cloud Atlas*
Cloudamize*
DEA
Cloudamize*
SQL Server Azure SQL VM DAMT / DMA DMA
Cloud Atlas*
Cloudamize*
DEA
Cloudamize*
SQL Server Azure Synapse Analytics DAMT
Amazon RDS for SQL Azure SQL DB, MI, VM DAMT / DMA DMA DEA
Oracle Azure SQL DB, MI, VM DAMT / SSMA SSMA
Oracle Azure Synapse Analytics DAMT / SSMA SSMA
Oracle Azure DB for PostgreSQL -
Single server
Ora2Pg*
Oracle Azure DB for PostgreSQL -
Flexible server
Ora2Pg*
MongoDB Azure Cosmos DB Cloudamize* Cloudamize*
Cassandra Azure Cosmos DB
MySQL Azure SQL DB, MI, VM DAMT / SSMA SSMA
Cloud Atlas*
MySQL Azure DB for MySQL
Amazon RDS for MySQL Azure DB for MySQL
PostgreSQL Azure DB for PostgreSQL -
Single server
PostgreSQL Azure DB for PostgreSQL -
Flexible server
Amazon RDS for PostgreSQL Azure DB for PostgreSQL -
Single server
DB2 Azure SQL DB, MI, VM DAMT / SSMA SSMA
Access Azure SQL DB, MI, VM SSMA
Sybase - SAP ASE Azure SQL DB, MI, VM DAMT / SSMA SSMA
Sybase - SAP IQ Azure SQL DB, MI, VM

Migration phase

Source Target Schema Data
(Offline)
Data
(Online)
SQL Server Azure SQL DB DMA
DMS
Cloudamize*
DMA
DMS
Cloudamize*
Cloudamize*
Qlik*
Striim*
SQL Server Azure SQL MI DMS
Cloudamize*
DMS
Cloudamize*
DMS
Cloudamize*
Qlik*
Striim*
SQL Server Azure SQL VM DMA
DMS
Cloudamize*
DMA
DMS
Cloudamize*
Cloudamize*
Qlik*
Striim*
SQL Server Azure Synapse Analytics
Amazon RDS for SQL Server Azure SQL DB DMA
DMS
DMA
DMS
Qlik*
Striim*
Amazon RDS for SQL Azure SQL MI DMS DMS DMS
Qlik*
Striim*
Amazon RDS for SQL Server Azure SQL VM DMA
DMS
DMA
DMS
Qlik*
Striim*
Oracle Azure SQL DB, MI, VM SSMA
SharePlex*
Ispirer*
SSMA
SharePlex*
Ispirer*
SharePlex*
Qlik*
Striim*
Oracle Azure Synapse Analytics SSMA
Ispirer*
SSMA
Ispirer*
SharePlex*
Qlik*
Striim*
Oracle Azure DB for PostgreSQL -
Single server
Ora2Pg*
Ispirer*
Ora2Pg*
Ispirer*

Striim*
Oracle Azure DB for PostgreSQL -
Flexible server
Ora2Pg*
Ispirer*
Ora2Pg*
Ispirer*

Striim*
MongoDB Azure Cosmos DB DMS
Cloudamize*
DMS
Cloudamize*
DMS
Cloudamize*
Striim*
MySQL Azure SQL DB, MI, VM SSMA
Ispirer*
SSMA
Ispirer*
Qlik*
Striim*
MySQL Azure DB for MySQL MySQL dump* DMS MyDumper/MyLoader* with data-in replication
Qlik*
Striim*
Amazon RDS for MySQL Azure DB for MySQL MySQL dump* DMS MyDumper/MyLoader* with data-in replication
Qlik*
Striim*
PostgreSQL Azure DB for PostgreSQL -
Single server
PG dump* PG dump* DMS
Qlik*
Striim*
Amazon RDS for PostgreSQL Azure DB for PostgreSQL -
Single server
PG dump* PG dump* DMS
Qlik*
Striim*
DB2 Azure SQL DB, MI, VM SSMA
Ispirer*
SSMA
Ispirer*
Qlik*
Striim*
Access Azure SQL DB, MI, VM SSMA SSMA SSMA
Sybase - SAP ASE Azure SQL DB, MI, VM SSMA
Ispirer*
SSMA
Ispirer*
Qlik*
Striim*
Sybase - SAP IQ Azure SQL DB, MI, VM Ispirer* Ispirer*

Post-migration phase

Source Target Optimize
SQL Server Azure SQL DB Cloud Atlas*
Cloudamize*
SQL Server Azure SQL MI Cloud Atlas*
Cloudamize*
SQL Server Azure SQL VM Cloud Atlas*
Cloudamize*
SQL Server Azure Synapse Analytics
RDS SQL Azure SQL DB, MI, VM
Oracle Azure SQL DB, MI, VM
Oracle Azure Synapse Analytics
Oracle Azure DB for PostgreSQL -
Single server
MongoDB Azure Cosmos DB Cloudamize*
Cassandra Azure Cosmos DB
MySQL Azure SQL DB, MI, VM
MySQL Azure DB for MySQL
Amazon RDS for MySQL Azure DB for MySQL
PostgreSQL Azure DB for PostgreSQL -
Single server
PostgreSQL Azure DB for PostgreSQL -
Flexible server
Amazon RDS for PostgreSQL Azure DB for PostgreSQL -
Single server
DB2 Azure SQL DB, MI, VM
Access Azure SQL DB, MI, VM
Sybase - SAP ASE Azure SQL DB, MI, VM
Sybase - SAP IQ Azure SQL DB, MI, VM

Next steps

For an overview of the Azure Database Migration Service, see the article What is the Azure Database Migration Service.