Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
Skip to content
Permalink
main
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Go to file
 
 
Cannot retrieve contributors at this time
title description services author ms.author manager ms.reviewer ms.service ms.workload ms.custom ms.topic ms.date
Azure Database Migration Service tools matrix
Learn about the services and tools available to migrate databases and to support various phases of the migration process.
database-migration
croblesm
roblescarlos
craigg
craigg
dms
data-services
mvc, ignite-2022
reference
03/03/2020

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 DB MAP Toolkit
Azure Migrate
Cloudamize*
DMA
Cloud Atlas*
Cloudamize*
TCO Calculator
SQL Server Azure SQL DB MI MAP Toolkit
Azure Migrate
Cloudamize*
DMA
Cloud Atlas*
Cloudamize*
TCO Calculator
SQL Server Azure SQL VM MAP Toolkit
Azure Migrate
Cloudamize*
Cloud Atlas*
Cloudamize*
TCO Calculator
SQL Server Azure Synapse Analytics MAP Toolkit
Azure Migrate
Cloudamize*
TCO Calculator
RDS SQL Azure SQL DB, MI, VM 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
RDS MySQL Azure DB for MySQL TCO Calculator
PostgreSQL Azure DB for PostgreSQL -
Single server
Azure Migrate TCO Calculator
RDS 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 DB 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
RDS 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*
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
RDS MySQL Azure DB for MySQL
PostgreSQL Azure DB for PostgreSQL -
Single server
RDS 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 Server dacpac extension
DMA
DMS
Cloudamize*
Azure SQL Migration extension
DMA
DMS
Cloudamize*
Cloudamize*
Attunity*
Striim*
SQL Server Azure SQL DB MI Azure SQL Migration extension
DMS
Cloudamize*
Azure SQL Migration extension
DMS
Cloudamize*
Azure SQL Migration extension
DMS
Cloudamize*
Attunity*
Striim*
SQL Server Azure SQL VM Azure SQL Migration extension
DMA
DMS
Cloudamize*
Azure SQL Migration extension
DMA
DMS
Cloudamize*
Azure SQL Migration extension
Cloudamize*
Attunity*
Striim*
SQL Server Azure Synapse Analytics
RDS SQL Azure SQL DB SQL Server dacpac extension
DMA
DMS
Azure SQL Migration extension
DMA
DMS
Attunity*
Striim*
RDS SQL Azure SQL DB MI DMS DMS DMS
Attunity*
Striim*
RDS SQL Azure SQL VM Azure SQL Migration extension
DMA
DMS
Azure SQL Migration extension
DMA
DMS
Azure SQL Migration extension
Attunity*
Striim*
Oracle Azure SQL DB, MI, VM SSMA
SharePlex*
Ispirer*
SSMA
SharePlex*
Ispirer*
SharePlex*
Attunity*
Striim*
Oracle Azure Synapse Analytics SSMA
Ispirer*
SSMA
Ispirer*
SharePlex*
Attunity*
Striim*
Oracle Azure DB for PostgreSQL -
Single server
Ispirer* Ispirer* Ora2Pg*
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*
Attunity*
Striim*
MySQL Azure DB for MySQL MySQL dump* DMS MyDumper/MyLoader* with data-in replication
Attunity*
Striim*
RDS MySQL Azure DB for MySQL MySQL dump* DMS MyDumper/MyLoader* with data-in replication
Attunity*
Striim*
PostgreSQL Azure DB for PostgreSQL -
Single server
PG dump* DMS
Attunity*
Striim*
RDS PostgreSQL Azure DB for PostgreSQL -
Single server
PG dump* DMS
Attunity*
Striim*
DB2 Azure SQL DB, MI, VM SSMA
Ispirer*
SSMA
Ispirer*
Attunity*
Striim*
Access Azure SQL DB, MI, VM SSMA SSMA SSMA
Sybase - SAP ASE Azure SQL DB, MI, VM SSMA
Ispirer*
SSMA
Ispirer*
Attunity*
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 DB 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
RDS MySQL Azure DB for MySQL
PostgreSQL Azure DB for PostgreSQL -
Single server
RDS 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.