Services and tools available for data migration scenarios
This article provides a matrix of the Microsoft 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* |
Azure SQL Migration extension DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
| SQL Server | Azure SQL Managed Instance | Azure Migrate Cloudamize* |
Azure SQL Migration extension DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
| SQL Server | SQL Server on Azure VM | Azure Migrate Cloudamize* |
Azure SQL Migration extension 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 | Azure SQL Migration extension 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* | |
| Cassandra | Azure Cosmos DB | |||
| 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 | Azure SQL Migration extension DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
| SQL Server | Azure SQL Managed Instance | DAMT / DMA | Azure SQL Migration extension DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
| SQL Server | SQL Server on Azure VM | DAMT / DMA | Azure SQL Migration extension 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 | Azure SQL Migration extension 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* | |
| Cassandra | Azure Cosmos DB | |||
| 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
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 |