Services and tools available for data migration scenarios

Статия
08/24/2023

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 DB	MAP Toolkit Azure Migrate Cloudamize*	Azure SQL Migration extension DMA Cloud Atlas* Cloudamize*	TCO Calculator
SQL Server	Azure SQL MI	MAP Toolkit Azure Migrate Cloudamize*	Azure SQL Migration extension DMA Cloud Atlas* Cloudamize*	TCO Calculator
SQL Server	Azure SQL VM	MAP Toolkit Azure Migrate Cloudamize*	Azure SQL Migration extension DMA Cloud Atlas* Cloudamize*	TCO Calculator
SQL Server	Azure Synapse Analytics	MAP Toolkit Azure Migrate Cloudamize*		TCO Calculator
Amazon RDS for SQL Server	Azure SQL DB, MI, VM		Azure SQL Migration extension DMA	TCO Calculator
Oracle	Azure SQL DB, MI, VM	MAP Toolkit Azure Migrate	SSMA MigVisor*
Oracle	Azure Synapse Analytics	MAP Toolkit Azure Migrate	SSMA
Oracle	Azure DB for PostgreSQL - Single server	MAP Toolkit Azure Migrate
MongoDB	Azure Cosmos DB	Cloudamize*	Cloudamize*
Cassandra	Azure Cosmos DB
MySQL	Azure SQL DB, MI, VM	Azure Migrate	SSMA Cloud Atlas*	TCO Calculator
MySQL	Azure DB for MySQL	Azure Migrate		TCO Calculator
Amazon RDS for MySQL	Azure DB for MySQL			TCO Calculator
PostgreSQL	Azure DB for PostgreSQL - Single server	Azure Migrate		TCO Calculator
Amazon RDS for PostgreSQL	Azure DB for PostgreSQL - Single server			TCO Calculator
DB2	Azure SQL DB, MI, VM	Azure Migrate	SSMA
Access	Azure SQL DB, MI, VM	Azure Migrate	SSMA
Sybase - SAP ASE	Azure SQL DB, MI, VM	Azure Migrate	SSMA
Sybase - SAP IQ	Azure SQL DB, MI, VM

Pre-migration phase

Source	Target	App Data Access Layer Assessment	Database Assessment	Performance Assessment
SQL Server	Azure SQL DB	DAMT / DMA	Azure SQL Migration extension DMA Cloud Atlas* Cloudamize*	DEA Cloudamize*
SQL Server	Azure SQL MI	DAMT / DMA	Azure SQL Migration extension DMA Cloud Atlas* Cloudamize*	DEA Cloudamize*
SQL Server	Azure SQL 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 DB, MI, VM	DAMT / DMA	Azure SQL Migration extension 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	SQL Database Projects extension DMA Cloudamize*	Azure SQL Migration extension DMA Cloudamize*	Cloudamize* Qlik* Striim*
SQL Server	Azure SQL MI	Azure SQL Migration extension Cloudamize*	Azure SQL Migration extension Cloudamize*	Azure SQL Migration extension Cloudamize* Qlik* Striim*
SQL Server	Azure SQL 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 DB	SQL Database Projects extension DMA	Azure SQL Migration extension DMA	Qlik* Striim*
Amazon RDS for SQL	Azure SQL MI	Azure SQL Migration extension	Azure SQL Migration extension	Azure SQL Migration extension Qlik* Striim*
Amazon RDS for SQL Server	Azure SQL VM	Azure SQL Migration extension DMA	Azure SQL Migration extension DMA	Azure SQL Migration extension 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* Imanis Data*	DMS Cloudamize* Imanis Data*	DMS Cloudamize* Imanis Data* Striim*
Cassandra	Azure Cosmos DB	Imanis Data*	Imanis Data*	Imanis Data*
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.

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