您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

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

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

备注

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

业务论证阶段Business justification phase

SourceSource 目标Target 发现 /Discover /
库存Inventory
目标和 SKUTarget and SKU
建议recommendation
TCO/ROI 和TCO/ROI and
业务案例Business case
SQL ServerSQL Server Azure SQL DBAzure SQL DB MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
Cloudamize*Cloudamize*
DMADMA
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
TCO 计算器TCO Calculator
SQL ServerSQL Server Azure SQL DB MIAzure SQL DB MI MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
Cloudamize*Cloudamize*
DMADMA
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
TCO 计算器TCO Calculator
SQL ServerSQL Server Azure SQL VMAzure SQL VM MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
Cloudamize*Cloudamize*
Cloud Atlas*Cloud Atlas*
Cloudamize*Cloudamize*
TCO 计算器TCO Calculator
SQL ServerSQL Server Azure Synapse AnalyticsAzure Synapse Analytics MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
Cloudamize*Cloudamize*
TCO 计算器TCO Calculator
RDS SQLRDS SQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM DMADMA TCO 计算器TCO Calculator
OracleOracle Azure SQL DB、MI、VMAzure SQL DB, MI, VM MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
SSMASSMA
MigVisor*MigVisor*
OracleOracle Azure Synapse AnalyticsAzure Synapse Analytics MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
SSMASSMA
OracleOracle Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
MAP 工具包MAP Toolkit
Azure MigrateAzure Migrate
MongoDBMongoDB Cosmos DBCosmos DB Cloudamize*Cloudamize* Cloudamize*Cloudamize*
CassandraCassandra Cosmos DBCosmos DB
MySQLMySQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM Azure MigrateAzure Migrate SSMASSMA
Cloud Atlas*Cloud Atlas*
TCO 计算器TCO Calculator
MySQLMySQL 用于 MySQL 的 Azure DBAzure DB for MySQL Azure MigrateAzure Migrate TCO 计算器TCO Calculator
RDS MySQLRDS MySQL 用于 MySQL 的 Azure DBAzure DB for MySQL TCO 计算器TCO Calculator
PostgreSQLPostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
Azure MigrateAzure Migrate TCO 计算器TCO Calculator
RDS PostgreSQLRDS PostgreSQL Azure DB for PostgreSQL -Azure DB for PostgreSQL -
单个服务器Single server
TCO 计算器TCO Calculator
DB2DB2 Azure SQL DB、MI、VMAzure SQL DB, MI, VM Azure MigrateAzure Migrate SSMASSMA
访问Access Azure SQL DB、MI、VMAzure SQL DB, MI, VM Azure MigrateAzure Migrate SSMASSMA
Sybase - SAP ASESybase - SAP ASE Azure SQL DB、MI、VMAzure SQL DB, MI, VM Azure MigrateAzure Migrate SSMASSMA
Sybase - SAP IQSybase - SAP IQ Azure SQL DB、MI、VMAzure SQL DB, MI, VM

迁移前阶段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 Azure Synapse AnalyticsAzure Synapse Analytics 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 Azure Synapse AnalyticsAzure Synapse Analytics 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 Azure Synapse AnalyticsAzure Synapse Analytics
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 Azure Synapse AnalyticsAzure Synapse Analytics 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 Azure Synapse AnalyticsAzure Synapse Analytics
RDS SQLRDS SQL Azure SQL DB、MI、VMAzure SQL DB, MI, VM
OracleOracle Azure SQL DB、MI、VMAzure SQL DB, MI, VM
OracleOracle Azure Synapse AnalyticsAzure Synapse Analytics
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.