Step by step Migration of SQL DB to Azure SQL Managed Instance with the help of Azure Data Migration Service – Part 1

As you are aware in my last post I have shown you the steps to create the Azure SQL Managed instance, today I will show you how you can migrate SQL databases easily to SQL managed instance.

For our PoC we have used the Azure DMS tool.

What is Azure Data Migration Service?

Azure Database Migration Service enables seamless migrations from multiple database sources to Azure Data platforms with minimal downtime. The service uses the Data Migration Assistant to generate assessment reports that provide recommendations to guide you through the changes required prior to performing a migration. When you’re ready to begin the migration process, the Azure Database Migration Service performs all of the required steps.

Why I have selected the DMS is that DMS support the Azure SQL Managed Instance as you can see below.

In the first step we need to register the Azure Data Migration Service.

Click on the register button in the top.

You can find the status as showing registering as you can see above. After waiting for couple of minutes it should show as registered as you can see below.

Next step is to create the Azure data migration service

We have selected the Standard Tier, this is free of cost as of now as you can find below.

In the next step click on the create button

You can see the deployment in progress.

In the next step you find the deployment is completed, as shown below.

Now you can see below the DMS service is created. J

That’s all for today, in part II of this post I have shown how to migrate the database to Azure SQL Managed Instance. Stay tuned.