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.
Business justification phase
Source | Target | Discover / Inventory |
Target and SKU recommendation |
TCO/ROI and Business case |
---|---|---|---|---|
SQL Server | Azure SQL Database | Azure Migrate Cloudamize* |
DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
SQL Server | Azure SQL Managed Instance | Azure Migrate Cloudamize* |
DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
SQL Server | SQL Server on Azure VM | Azure Migrate Cloudamize* |
DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
SQL Server | Azure Synapse Analytics | Azure Migrate Cloudamize* |
TCO Calculator | |
Amazon RDS for SQL Server | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DMA | TCO Calculator | |
Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Azure Migrate | SSMA MigVisor* |
|
Oracle | Azure Synapse Analytics | Azure Migrate | SSMA | |
Oracle | Azure Database for PostgreSQL - Flexible server |
Azure Migrate | ||
MongoDB | Azure Cosmos DB | Cloudamize* | Cloudamize* | |
MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Azure Migrate | SSMA Cloud Atlas* |
TCO Calculator |
MySQL | Azure Database for MySQL | Azure Migrate | TCO Calculator | |
Amazon RDS for MySQL | Azure Database for MySQL | TCO Calculator | ||
PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Azure Migrate | TCO Calculator | |
Amazon RDS for PostgreSQL | Azure Database for PostgreSQL - Flexible server |
TCO Calculator | ||
DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Azure Migrate | SSMA | |
Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Azure Migrate | SSMA | |
Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Azure Migrate | SSMA | |
Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM |
Premigration phase
Source | Target | App Data Access Layer Assessment |
Database Assessment |
Performance Assessment |
---|---|---|---|---|
SQL Server | Azure SQL Database | DAMT / DMA | DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
SQL Server | Azure SQL Managed Instance | DAMT / DMA | DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
SQL Server | SQL Server on Azure VM | DAMT / DMA | DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
SQL Server | Azure Synapse Analytics | DAMT | ||
Amazon RDS for SQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DAMT / DMA | DMA | DEA |
Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DAMT / SSMA | SSMA | |
Oracle | Azure Synapse Analytics | DAMT / SSMA | SSMA | |
Oracle | Azure Database for PostgreSQL - Flexible server |
Ora2Pg* | ||
MongoDB | Azure Cosmos DB | Cloudamize* | Cloudamize* | |
MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DAMT / SSMA | SSMA Cloud Atlas* |
|
MySQL | Azure Database for MySQL | |||
Amazon RDS for MySQL | Azure Database for MySQL | |||
PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | ||
Amazon RDS for PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | ||
Amazon Aurora PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | ||
Google Cloud SQL for PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | ||
DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DAMT / SSMA | SSMA | |
Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA | ||
Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | DAMT / SSMA | SSMA | |
Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM |
Migration phase
Source | Target | Schema | Data (Offline) |
Data (Online) |
---|---|---|---|---|
SQL Server | Azure SQL Database | DMA Cloudamize* |
DMA Cloudamize* |
Cloudamize* Qlik* Striim* |
SQL Server | Azure SQL Managed Instance | Cloudamize* | Cloudamize* | Cloudamize* Qlik* Striim* |
SQL Server | SQL Server on Azure VM | DMA Cloudamize* |
DMA Cloudamize* |
Cloudamize* Qlik* Striim* |
SQL Server | Azure Synapse Analytics | |||
Amazon RDS for SQL Server | Azure SQL Database | DMA | DMA | Qlik* Striim* |
Amazon RDS for SQL | Azure SQL Managed Instance | Qlik* Striim* |
||
Amazon RDS for SQL Server | SQL Server on Azure VM | DMA | DMA | Qlik* Striim* |
Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA SharePlex* Ispirer* |
SSMA SharePlex* Ispirer* |
SharePlex* Qlik* Striim* |
Oracle | Azure Synapse Analytics | SSMA Ispirer* |
SSMA Ispirer* |
SharePlex* Qlik* Striim* |
Oracle | Azure Database for PostgreSQL - Flexible server |
Ora2Pg* Ispirer* |
Ora2Pg* Ispirer* |
Striim* |
MongoDB | Azure Cosmos DB | DMS Cloudamize* |
DMS Cloudamize* |
DMS Cloudamize* Striim* |
MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
MySQL | Azure Database for MySQL | MySQL dump* | DMS | MyDumper/MyLoader* with data-in replication Qlik* Striim* |
Amazon RDS for MySQL | Azure Database for MySQL | MySQL dump* | DMS | MyDumper/MyLoader* with data-in replication Qlik* Striim* |
PostgreSQL | Azure Database for PostgreSQL - Single server |
PG dump* | PG dump* | DMS Qlik* Striim* |
Amazon RDS for PostgreSQL | Azure Database for PostgreSQL - Single server |
PG dump* | PG dump* | DMS Qlik* Striim* |
Google Cloud SQL for PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | Migration Service for Azure Database for PostgreSQL | Migration Service for Azure Database for PostgreSQL |
Amazon Aurora PostgreSQL | Azure Database for PostgreSQL - Flexible server |
Migration Service for Azure Database for PostgreSQL | Migration Service for Azure Database for PostgreSQL | Migration Service for Azure Database for PostgreSQL |
DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA | SSMA | SSMA |
Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | Ispirer* | Ispirer* |
Post-migration phase
Source | Target | Optimize |
---|---|---|
SQL Server | Azure SQL Database | Cloud Atlas* Cloudamize* |
SQL Server | Azure SQL Managed Instance | Cloud Atlas* Cloudamize* |
SQL Server | SQL Server on Azure VM | Cloud Atlas* Cloudamize* |
SQL Server | Azure Synapse Analytics | |
RDS SQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
Oracle | Azure Synapse Analytics | |
Oracle | Azure Database for PostgreSQL - Single server |
|
MongoDB | Azure Cosmos DB | Cloudamize* |
Cassandra | Azure Cosmos DB | |
MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
MySQL | Azure Database for MySQL | |
Amazon RDS for MySQL | Azure Database for MySQL | |
PostgreSQL | Azure Database for PostgreSQL - Flexible server |
|
Amazon RDS for PostgreSQL | Azure Database for PostgreSQL - Flexible server |
|
DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM | |
Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM |