Azure Database Migration Service is a fully managed service designed to enable seamless migrations from multiple database sources to Azure data platforms with minimal downtime (online migrations).
With Azure Database Migration Service currently we offer two versions:
Database Migration Service (classic) - via Azure portal, PowerShell and Azure CLI.
Database Migration Service powers the "Azure SQL Migration" extension for Azure Data Studio, and provides more features. Azure portal, PowerShell and Azure CLI can also be used to access DMS. Currently, it supports SQL Database modernization to Azure. For improved functionality and supportability, consider migrating to Azure SQL Database by using the DMS.
Database Migration Service (classic) via Azure portal, PowerShell and Azure CLI is an older version of the Azure Database Migration Service. It offers database modernization to Azure and support scenarios like – SQL Server, PostgreSQL, MySQL, and MongoDB.
A responsive user interface that provides you with an end-to-end migration experience that starts with a migration readiness assessment, and SKU recommendation (based on performance data), and finalizes with the actual migration to Azure SQL.
An enhanced assessment mechanism that can evaluate SQL Server instances, identifying databases that are ready for migration to the different Azure SQL targets.
An SKU recommendations engine (Preview) that collects performance data from the source SQL Server instance on-premises, generating right-sized SKU recommendations based on your Azure SQL target.
A reliable Azure service powered by Azure Database Migration Service that orchestrates data movement activities to deliver a seamless migration experience.
The ability to run online (for migrations requiring minimal downtime) or offline (for migrations where downtime persists through the migration) migration modes to suit your business requirements.
The flexibility to create and configure a self-hosted integration runtime to provide your own compute for accessing the source SQL Server and backups in your on-premises environment.
Provides a secure and improved user experience for migrating TDE databases and SQL/Windows logins to Azure SQL.
Check the following step-by-step tutorials for more information about each specific migration scenario by Azure SQL target:
Newer version of the Azure Database Migration Service is available as an extension for Azure Data Studio and can be accesses from Azure portal, which improved the functionality, user experience and supportability of the migration service. Consider using the Azure SQL Migration extension for Azure Data Studio and DMS Azure portal whenever possible.
The following table compares the functionality of the versions of the Database Migration Service:
Feature
DMS(classic)
DMS - via Azure SQL extension for ADS
DMS - via Azure portal
Notes
Assessment
No
Yes
No
Assess compatibility of the source.
SKU recommendation
No
Yes
No
SKU recommendations for the target based on the assessment of the source.
Azure SQL Database - Offline migration
Yes
Yes
Yes
Migrate to Azure SQL Database offline.
Azure SQL Managed Instance - Online migration
Yes
Yes
Yes
Migrate to Azure SQL Managed Instance online with minimal downtime.
Azure SQL Managed Instance - Offline migration
Yes
Yes
Yes
Migrate to Azure SQL Managed Instance offline.
SQL Server on Azure SQL VM - Online migration
No
Yes
Yes
Migrate to SQL Server on Azure VMs online with minimal downtime.
SQL Server on Azure SQL VM - Offline migration
Yes
Yes
Yes
Migrate to SQL Server on Azure VMs offline.
Migrate logins
Yes
Yes
No
Migrate logins from your source to your target.
Migrate schemas
Yes
No
Yes
Migrate schemas from your source to your target.
Azure portal support
Yes
Partial
Yes
Create and Monitor your migration by using the Azure portal.
Integration with Azure Data Studio
No
Yes
No
Migration support integrated with Azure Data Studio.
Regional availability
Yes
Yes
Yes
More regions are available with the extension.
Improved user experience
No
Yes
Yes
The DMS is faster, more secure, and easier to troubleshoot.
Automation
Yes
Yes
Yes
The DMS supports PowerShell and Azure CLI.
Private endpoints
No
Yes
Yes
Connect to your source and target using private endpoints.
TDE support
No
Yes
No
Migrate databases encrypted with TDE.
Migrate databases to Azure with familiar tools
Azure Database Migration Service integrates some of the functionality of our existing tools and services. It provides customers with a comprehensive, highly available solution. The service uses the Data Migration Assistant to generate assessment reports that provide recommendations to guide you through the required changes before a migration. It's up to you to perform any remediation required. Azure Database Migration Service performs all the required steps when ready to begin the migration process. Knowing that the process takes advantage of Microsoft's best practices, you can fire and forget your migration projects with peace of mind.
Regional availability
For up-to-date info about the regional availability of Azure Database Migration Service, see Products available by region.
Learn the essentials of Azure SQL Database deployment and migration. Explore its benefits, exclusive features, and migration options while optimizing performance and application connections for a smooth transition to the cloud.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.