Services en hulpprogramma's voor gegevensmigratiescenario's
Dit artikel bevat een matrix van de services en hulpprogramma's van Microsoft en derden die u kunnen helpen bij verschillende database- en gegevensmigratiescenario's en speciale taken.
In de volgende tabellen worden de services en hulpprogramma's geïdentificeerd die u kunt gebruiken om gegevensmigratie te plannen en de verschillende fasen te voltooien.
Notitie
In de volgende tabellen vertegenwoordigen items die zijn gemarkeerd met een sterretje (*) hulpprogramma's van derden.
Fase zakelijke rechtvaardiging
| Source | Target | Ontdekken/ Voorraad |
Doel en SKU aanbeveling |
TCO/ROI en Bedrijfsgeval |
|---|---|---|---|---|
| SQL Server | Azure SQL Database | Azure Migrate Cloudamize* |
Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
| SQL Server | Azure SQL Managed Instance | Azure Migrate Cloudamize* |
Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
| SQL Server | SQL Server op Azure VM | Azure Migrate Cloudamize* |
Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
TCO Calculator |
| SQL Server | Azure Synapse Analytics | Azure Migrate Cloudamize* |
TCO Calculator | |
| Amazon RDS voor SQL Server | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure SQL Migratie-extensie DMA |
TCO Calculator | |
| Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure Migrate | SSMA MigVisor* |
|
| Oracle | Azure Synapse Analytics | Azure Migrate | SSMA | |
| Oracle | Azure Database for PostgreSQL - Enkele server |
Azure Migrate | ||
| MongoDB | Azure Cosmos DB | Cloudamize* | Cloudamize* | |
| Cassandra | Azure Cosmos DB | |||
| MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure Migrate | SSMA Cloud Atlas* |
TCO Calculator |
| MySQL | Azure Database for MySQL | Azure Migrate | TCO Calculator | |
| Amazon RDS voor MySQL | Azure Database for MySQL | TCO Calculator | ||
| PostgreSQL | Azure Database for PostgreSQL - Enkele server |
Azure Migrate | TCO Calculator | |
| Amazon RDS voor PostgreSQL | Azure Database for PostgreSQL - Enkele server |
TCO Calculator | ||
| DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure Migrate | SSMA | |
| Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure Migrate | SSMA | |
| Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Azure Migrate | SSMA | |
| Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM |
Premigratiefase
| Source | Target | App Data Access Laagevaluatie |
Database Beoordeling |
Prestaties Beoordeling |
|---|---|---|---|---|
| SQL Server | Azure SQL Database | DAMT / DMA | Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
| SQL Server | Azure SQL Managed Instance | DAMT / DMA | Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
| SQL Server | SQL Server op Azure VM | DAMT / DMA | Azure SQL Migratie-extensie DMA Cloud Atlas* Cloudamize* |
DEA Cloudamize* |
| SQL Server | Azure Synapse Analytics | DAMT | ||
| Amazon RDS voor SQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | DAMT / DMA | Azure SQL Migratie-extensie DMA |
DEA |
| Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | DAMT / SSMA | SSMA | |
| Oracle | Azure Synapse Analytics | DAMT / SSMA | SSMA | |
| Oracle | Azure Database for PostgreSQL - Enkele server |
Ora2pg* | ||
| Oracle | Azure Database for PostgreSQL - Flexibele server |
Ora2pg* | ||
| MongoDB | Azure Cosmos DB | Cloudamize* | Cloudamize* | |
| Cassandra | Azure Cosmos DB | |||
| MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | DAMT / SSMA | SSMA Cloud Atlas* |
|
| MySQL | Azure Database for MySQL | |||
| Amazon RDS voor MySQL | Azure Database for MySQL | |||
| PostgreSQL | Azure Database for PostgreSQL - Enkele server |
|||
| PostgreSQL | Azure Database for PostgreSQL - Flexibele server |
|||
| Amazon RDS voor PostgreSQL | Azure Database for PostgreSQL - Enkele server |
|||
| DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | DAMT / SSMA | SSMA | |
| Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | SSMA | ||
| Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | DAMT / SSMA | SSMA | |
| Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM |
Migratiefase
| Source | Target | Schema | Gegevens (Offline) |
Gegevens (Online) |
|---|---|---|---|---|
| SQL Server | Azure SQL Database | SQL databaseprojecten-extensie DMA Cloudamize* |
Azure SQL Migratie-extensie DMA Cloudamize* |
Cloudamize* Qlik* Striim* |
| SQL Server | Azure SQL Managed Instance | Azure SQL Migratie-extensie Cloudamize* |
Azure SQL Migratie-extensie Cloudamize* |
Azure SQL Migratie-extensie Cloudamize* Qlik* Striim* |
| SQL Server | SQL Server op Azure VM | Azure SQL Migratie-extensie DMA Cloudamize* |
Azure SQL Migratie-extensie DMA Cloudamize* |
Azure SQL Migratie-extensie Cloudamize* Qlik* Striim* |
| SQL Server | Azure Synapse Analytics | |||
| Amazon RDS voor SQL Server | Azure SQL-database | SQL databaseprojecten-extensie DMA |
Azure SQL Migratie-extensie DMA |
Qlik* Striim* |
| Amazon RDS voor SQL | Azure SQL Managed Instance | Azure SQL Migratie-extensie | Azure SQL Migratie-extensie | Azure SQL Migratie-extensie Qlik* Striim* |
| Amazon RDS voor SQL Server | SQL Server op Azure VM | Azure SQL Migratie-extensie DMA |
Azure SQL Migratie-extensie DMA |
Azure SQL Migratie-extensie Qlik* Striim* |
| Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server op 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 - Enkele server |
Ora2pg* Ispirer* |
Ora2pg* Ispirer* |
Striim* |
| Oracle | Azure Database for PostgreSQL - Flexibele 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 op Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
| MySQL | Azure Database for MySQL | MySQL-dump* | DMS | MyDumper/MyLoader* met replicatie van gegevens Qlik* Striim* |
| Amazon RDS voor MySQL | Azure Database for MySQL | MySQL-dump* | DMS | MyDumper/MyLoader* met replicatie van gegevens Qlik* Striim* |
| PostgreSQL | Azure Database for PostgreSQL - Enkele server |
PG-dump* | PG-dump* | DMS Qlik* Striim* |
| Amazon RDS voor PostgreSQL | Azure Database for PostgreSQL - Enkele server |
PG-dump* | PG-dump* | DMS Qlik* Striim* |
| DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
| Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | SSMA | SSMA | SSMA |
| Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | SSMA Ispirer* |
SSMA Ispirer* |
Qlik* Striim* |
| Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | Ispirer* | Ispirer* |
Fase na migratie
| Source | Target | Optimaliseren |
|---|---|---|
| SQL Server | Azure SQL Database | Cloud Atlas* Cloudamize* |
| SQL Server | Azure SQL Managed Instance | Cloud Atlas* Cloudamize* |
| SQL Server | SQL Server op Azure VM | Cloud Atlas* Cloudamize* |
| SQL Server | Azure Synapse Analytics | |
| RDS SQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| Oracle | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| Oracle | Azure Synapse Analytics | |
| Oracle | Azure Database for PostgreSQL - Enkele server |
|
| MongoDB | Azure Cosmos DB | Cloudamize* |
| Cassandra | Azure Cosmos DB | |
| MySQL | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| MySQL | Azure Database for MySQL | |
| Amazon RDS voor MySQL | Azure Database for MySQL | |
| PostgreSQL | Azure Database for PostgreSQL - Enkele server |
|
| PostgreSQL | Azure Database for PostgreSQL - Flexibele server |
|
| Amazon RDS voor PostgreSQL | Azure Database for PostgreSQL - Enkele server |
|
| DB2 | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| Access | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| Sybase - SAP ASE | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM | |
| Sybase - SAP IQ | Azure SQL Database, Azure SQL Managed Instance, SQL Server op Azure VM |