Редактиране

Споделяне чрез


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 -
Single 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 -
Single server
Azure Migrate TCO Calculator
Amazon RDS for PostgreSQL Azure Database for PostgreSQL -
Single 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 -
Single server
Ora2Pg*
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 -
Single server
PostgreSQL Azure Database for PostgreSQL -
Flexible server
Amazon RDS for PostgreSQL Azure Database for PostgreSQL -
Single server
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 SQL Database Projects extension
DMA
Cloudamize*
Azure SQL Migration extension
DMA
Cloudamize*
Cloudamize*
Qlik*
Striim*
SQL Server Azure SQL Managed Instance Azure SQL Migration extension
Cloudamize*
Azure SQL Migration extension
Cloudamize*
Azure SQL Migration extension
Cloudamize*
Qlik*
Striim*
SQL Server SQL Server on Azure VM Azure SQL Migration extension
DMA
Cloudamize*
Azure SQL Migration extension
DMA
Cloudamize*
Azure SQL Migration extension
Cloudamize*
Qlik*
Striim*
SQL Server Azure Synapse Analytics
Amazon RDS for SQL Server Azure SQL Database SQL Database Projects extension
DMA
Azure SQL Migration extension
DMA
Qlik*
Striim*
Amazon RDS for SQL Azure SQL Managed Instance Azure SQL Migration extension Azure SQL Migration extension Azure SQL Migration extension
Qlik*
Striim*
Amazon RDS for SQL Server SQL Server on Azure VM Azure SQL Migration extension
DMA
Azure SQL Migration extension
DMA
Azure SQL Migration extension
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 -
Single server
Ora2Pg*
Ispirer*
Ora2Pg*
Ispirer*

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

Striim*
MongoDB Azure Cosmos DB DMS
Cloudamize*
Imanis Data*
DMS
Cloudamize*
Imanis Data*
DMS
Cloudamize*
Imanis Data*
Striim*
Cassandra Azure Cosmos DB Imanis Data* Imanis Data* Imanis Data*
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*
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 -
Single server
PostgreSQL Azure Database for PostgreSQL -
Flexible server
Amazon RDS for PostgreSQL Azure Database for PostgreSQL -
Single 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