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.