可用于数据迁移方案的服务和工具Services and tools available for data migration scenarios

本文提供了在执行各种数据库和数据迁移方案及专门任务时可为你提供帮助的 Azure 与第三方服务和工具的矩阵。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 that you can use to plan successfully for data migration and to complete its various phases.

Note

在以下各表中,标有星号 (*) 的项表示第三方工具。In the following tables, items marked with an asterisk (*) represent third-party tools.

迁移前阶段Pre-migration phase

SourceSource 目标Target 应用数据访问App Data Access
层评估Layer Assessment
数据库Database
评估Assessment
性能Performance
评估Assessment
SQL ServerSQL Server Azure SQL DBAzure SQL DB DAMT / DMADAMT / DMA DMADMA
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
DEADEA
Cloudamize*Cloudamize*
SQL ServerSQL Server Azure SQL DB MIAzure SQL DB MI DAMT / DMADAMT / DMA DMADMA
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
DEADEA
Cloudamize*Cloudamize*
SQL ServerSQL Server Azure SQL VMAzure SQL VM DAMT / DMADAMT / DMA DMADMA
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
DEADEA
Cloudamize*Cloudamize*
SQL ServerSQL Server SQL DWSQL DW DAMTDAMT
RDS SQLRDS SQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM DAMT / DMADAMT / DMA DMADMA DEADEA
OracleOracle Azure SQL DB、MI、VMAzure SQL DB, MI, VM DAMT / SSMADAMT / SSMA SSMASSMA
OracleOracle SQL DWSQL DW DAMT / SSMADAMT / SSMA SSMASSMA
OracleOracle Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
Ora2Pg*Ora2Pg*
MongoDBMongoDB Cosmos DBCosmos DB Cloudamize*Cloudamize* Cloudamize*Cloudamize*
CassandraCassandra Cosmos DBCosmos DB
MySQLMySQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM DAMT / SSMADAMT / SSMA SSMASSMA
Cloud Atlas*Cloud Atlas*
MySQLMySQL 用于 MySQL 的 Azure DBAzure DB for MySQL
RDS MySQLRDS MySQL 用于 MySQL 的 Azure DBAzure DB for MySQL
PostgreSQLPostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
RDS PostgreSQLRDS PostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
DB2DB2 Azure SQL DB、MI、VMAzure SQL DB, MI, VM DAMT / SSMADAMT / SSMA SSMASSMA
访问Access Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA
Sybase - SAP ASESybase - SAP ASE Azure SQL DB、MI、VMAzure SQL DB, MI, VM DAMT / SSMADAMT / SSMA SSMASSMA
Sybase - SAP IQSybase - SAP IQ Azure SQL DB、MI、VMAzure SQL DB, MI, VM

迁移阶段Migration phase

SourceSource 目标Target 架构Schema 数据Data
(脱机)(Offline)
数据Data
(联机)(Online)
SQL ServerSQL Server Azure SQL DBAzure SQL DB DMADMA
Cloudamize*Cloudamize*
DMSDMS
Cloudamize*Cloudamize*
DMSDMS
Cloudamize*Cloudamize*
Attunity*Attunity*
Striim*Striim*
SQL ServerSQL Server Azure SQL DB MIAzure SQL DB MI DMSDMS
Cloudamize*Cloudamize*
DMSDMS
Cloudamize*Cloudamize*
DMSDMS
Cloudamize*Cloudamize*
Attunity*Attunity*
Striim*Striim*
SQL ServerSQL Server Azure SQL VMAzure SQL VM DMADMA
DMSDMS
Cloudamize*Cloudamize*
DMADMA
DMSDMS
Cloudamize*Cloudamize*
DMSDMS
Cloudamize*Cloudamize*
Attunity*Attunity*
Striim*Striim*
SQL ServerSQL Server SQL DWSQL DW
RDS SQLRDS SQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM DMADMA DMADMA
DMSDMS
DMSDMS
Attunity*Attunity*
Striim*Striim*
OracleOracle Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA
SharePlex*SharePlex*
Ispirer*Ispirer*
SSMASSMA
SharePlex*SharePlex*
Ispirer*Ispirer*
DMSDMS
SharePlex*SharePlex*
Attunity*Attunity*
Striim*Striim*
OracleOracle SQL DWSQL DW SSMASSMA
Ispirer*Ispirer*
SSMASSMA
Ispirer*Ispirer*
DMSDMS
SharePlex*SharePlex*
Attunity*Attunity*
Striim*Striim*
OracleOracle Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
Ispirer*Ispirer* Ispirer*Ispirer* DMSDMS
MongoDBMongoDB Cosmos DBCosmos DB DMSDMS
Cloudamize*Cloudamize*
Imanis Data*Imanis Data*
DMSDMS
Cloudamize*Cloudamize*
Imanis Data*Imanis Data*
DMSDMS
Cloudamize*Cloudamize*
Imanis Data*Imanis Data*
Striim*Striim*
CassandraCassandra Cosmos DBCosmos DB Imanis Data*Imanis Data* Imanis Data*Imanis Data* Imanis Data*Imanis Data*
MySQLMySQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA
Ispirer*Ispirer*
SSMASSMA
Ispirer*Ispirer*
Attunity*Attunity*
Striim*Striim*
MySQLMySQL 用于 MySQL 的 Azure DBAzure DB for MySQL MySQL dump*MySQL dump* DMSDMS
Attunity*Attunity*
Striim*Striim*
RDS MySQLRDS MySQL 用于 MySQL 的 Azure DBAzure DB for MySQL MySQL dump*MySQL dump* DMSDMS
Attunity*Attunity*
Striim*Striim*
PostgreSQLPostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
PG dump*PG dump* DMSDMS
Attunity*Attunity*
Striim*Striim*
RDS PostgreSQLRDS PostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
PG dump*PG dump* DMSDMS
Attunity*Attunity*
Striim*Striim*
DB2DB2 Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA
Ispirer*Ispirer*
SSMASSMA
Ispirer*Ispirer*
Attunity*Attunity*
Striim*Striim*
访问Access Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA SSMASSMA SSMASSMA
Sybase - SAP ASESybase - SAP ASE Azure SQL DB、MI、VMAzure SQL DB, MI, VM SSMASSMA
Ispirer*Ispirer*
SSMASSMA
Ispirer*Ispirer*
Attunity*Attunity*
Striim*Striim*
Sybase - SAP IQSybase - SAP IQ Azure SQL DB、MI、VMAzure SQL DB, MI, VM Ispirer*Ispirer* Ispirer*Ispirer*

迁移后阶段Post-migration phase

SourceSource 目标Target 优化Optimize
SQL ServerSQL Server Azure SQL DBAzure SQL DB Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
SQL ServerSQL Server Azure SQL DB MIAzure SQL DB MI Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
SQL ServerSQL Server Azure SQL VMAzure SQL VM Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
SQL ServerSQL Server SQL DWSQL DW
RDS SQLRDS SQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM
OracleOracle Azure SQL DB、MI、VMAzure SQL DB, MI, VM
OracleOracle SQL DWSQL DW
OracleOracle Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
MongoDBMongoDB Cosmos DBCosmos DB Cloudamize*Cloudamize*
CassandraCassandra Cosmos DBCosmos DB
MySQLMySQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM
MySQLMySQL 用于 MySQL 的 Azure DBAzure DB for MySQL
RDS MySQLRDS MySQL 用于 MySQL 的 Azure DBAzure DB for MySQL
PostgreSQLPostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
RDS PostgreSQLRDS PostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
DB2DB2 Azure SQL DB、MI、VMAzure SQL DB, MI, VM
访问Access Azure SQL DB、MI、VMAzure SQL DB, MI, VM
Sybase - SAP ASESybase - SAP ASE Azure SQL DB、MI、VMAzure SQL DB, MI, VM
Sybase - SAP IQSybase - SAP IQ Azure SQL DB、MI、VMAzure SQL DB, MI, VM

后续步骤Next steps

有关 Azure 数据库迁移服务的概述,请参阅什么是 Azure 数据库迁移服务一文。For an overview of the Azure Database Migration Service, see the article What is the Azure Database Migration Service.