הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
Microsoft provides a suite of tools and services to assist users with migrating various source databases to different target environments.
This article provides a brief overview of the tools available to migrate to SQL Server and Azure SQL.
Azure Database Migration Service (DMS)
Azure Database Migration Service enables seamless migrations from SQL Server database sources to Azure SQL offerings with minimal downtime. The Database Migration Service provides a resilient and reliable migration pipeline that requires minimal user involvement during the overall migration process.
Azure Database Migration Service can be accessed via the Azure portal, PowerShell, and Azure CLI.
Use the latest Azure Database Migration Service in the following scenarios:
Migrate both databases to Azure SQL, especially at scale, and for extensive (in terms of number and size of databases) migrations.
Migrate databases to Azure SQL Database.
For more information, visit Azure Database Migration Service documentation.
Azure Migrate
Azure Migrate provides a centralized hub to discover and assess on-premises servers, infrastructure, applications, and data to Azure at scale. Azure Migrate offers a unified migration across your servers, databases, and applications.
Use Azure Migrate to discover all your SQL Server instances across your datacenter, assess application dependencies, and understand the readiness of these SQL Server instances migrating to Azure SQL. You get Microsoft recommendations, such as the optimal Azure SQL deployment option and the correct offering that can fit the performance needs for your workloads, and monthly estimates for running these databases on Azure SQL to cater to your licensing benefits.
Use Azure Migrate in the following scenarios:
- Assess and discover your SQL Server data estate.
- Get Azure SQL deployment recommendations, target sizing, and monthly estimates.
- Lift your entire data estate to SQL Server on Azure Virtual Machines.
For more information, visit Azure Migrate documentation.
SQL Server Migration Assistant (SSMA)
SQL Server Migration Assistant (SSMA) is a tool designed to automate database migration to SQL Server and Azure SQL from alternative database engines.
Use SSMA in the following scenario:
- Migrate Microsoft Access, Db2, MySQL, Oracle, and SAP ASE databases to SQL Server.
- Migrate Microsoft Access, Db2, MySQL, Oracle, and SAP ASE databases to Azure SQL.
For more information, visit SQL Server Migration Assistant.
Migration tool comparison
Use the following chart to compare capabilities of the SQL migration tools:
| Capability | Azure Migrate | SQL migration component | SSMA | Azure Arc | DMS (Azure Portal / PowerShell / az cmdlet) |
|---|---|---|---|---|---|
| Discover and assess SQL data estate | At scale | Yes | No | Yes | Using PS / cmdlet |
| Migrate SQL Server objects to SQL Database or SQL Managed Instance | No | No | No | Yes | Yes |
| Lift and shift SQL Server to SQL Server on Azure VM | Yes | No | No | No | Yes |
| Migrate (and/or upgrade) SQL Server to SQL Server on Azure VM | No | Yes | No | Yes | Yes |
| Migrate non-SQL objects (Oracle, Access, Db2, etc.) |
No | No | Yes | No | No |
| Migrate open source databases (MySQL, PostgreSQL, MariaDB, etc.) |
No | No | No | No | No |