Introduction to Azure Database Migration Service (ADMS)

4 min readNov 6, 2020


Microsoft Azure platform provides an Azure Database Migration Service (ADMS) — a convenient solution for the Azure Cloud-based Databases migration tasks in a straight forward way. In this article, we elaborate on the AMDS essential work and integrated processes.

We put in the focus issues related to the migration of object resources on Cloud to Cloud and on-premises database server to cloud. Also, we’ll deal with the cross-database migration compatibility between different database technologies.

ADMS supports several Automation migration tasks for data migration on Azure platform from SQL Server, MySQL, AWS RDS for MySQL, PostgreSQL, AWS RDS for PostgreSQL, Oracle, AWS RDS for SQL Server, and NoSQL Server (MongoDB).

Why Azure Database Migration Service (ADMS)?

Many organizations upgrade their platform technologies and shift toward Cloud technology. It endorses new technologies and lowers infrastructure costs. Azure Database Migration Services works as an arbitrator between the two data sources: it helps to migrate schemas, objects, and data between two databases or database servers.

The primary concern is how to move an existing database structure and information to the Cloud?

Typically, when we migrate data from the current setup to the Azure database, DBAs have to plan and prepare schema migration scripts, data migration scripts, and other assets in the server migration process. The source and destination can have different data type support and different syntax for the programmability objects (e.g., MySQL to Azure database).

While shifting the on-premises data to the cloud database via ADMS, we can rely on the Azure migration solutions. It won’t matter if the source database uses the same technology or a different one.

Users can also choose to automatically design the data migration, which is a significant plus of this service. Moreover, according to the users’ requirements, ADMS allows us to synchronize the information in the runtime or periodically. Cross-database technologies at the migration origin and destination, which are among the most tedious tasks for the DBA, become simpler with ADMS.

It is a pretty convenient service for migration on the Cloud. Microsoft has designed it in a way that it can execute a quick migration from a massive source to the Azure database. There are several key steps to configure the first migration service before constructing a new Migration Project. Further, we’ll build our first Azure Database Migration Service.

Azure Database Migration Services (ADMS) is included in the Migrate category of the “All services” list on the Azure portal dashboard.

All Services > Migrate > Azure Database Migration Services

Setting up a new Migration Service

Firstly, we need to choose the Subscription Plan, as the migration services’ charges depend on this subscription plan. However, the user gets a total bill for all subscriptions.

Second, we must select the Resource group to distinguish and host our necessary service. It is possible to create a new resource group by a user, or you can bridge this service with it as well.

In this example, we have selected the “Adventure” resource group. The next step is to specify the instance name for this service.

We have defined the Migration Service Name as AdventureMigration. The location we set is East US, where we want to execute the instance of this service. Users can choose the site location as per their destination site. It is very convenient for managing the ADMS service on the site/location where the destination project runs.

Service mode specifies the worker or resource configuration for the service. Two service modes are available for ADMS: Azure and Hybrid.

  • Azure Service mode hosts ADMS in the Azure platform as service.
  • Hybrid Service mode hosts ADMS on the on-premises setup.

Users can set up the Azure service mode based on the migration process requirements and nature. Offline and online migration tasks are available in Premium, while Standard provides offline migrations only.

Continue reading at 👉

Join a community of database administrators and Microsoft stack technologies specialists. Subscribe here to get more industry insides 👋




Awesome blog focused on databases and Microsoft, .NET and cloud technologies.