Migration of SQL DB to Azure SQL Managed Instance

SQL DB

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.

dms

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

M2

Click on the register button in the top.

m3

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.

M4

Next step is to create the Azure data migration service

M5

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

M6

In the next step click on the create button

M7

You can see the deployment in progress.

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

M9

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

M10

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

In this 2nd part I will show you how you can actually migrate the database.

As you have seen in the last post once the DMS is created, it will show like this below.

azM1

In the next step you need to create New Migration Project. You should click on new migration project. Once you will click on that it will show you this dialog box as you can show below.

azM2

And in next step you need to give the source of the SQL Server instance from where you need to migrate the database.

azM3

Since the source server connection data I would like to encrypt during transit so I have selected this option

azM4

In the next step you need to specify the target database instance which is our SQL Managed Instance in Azure as you can see below

azM5

Now in next step you need to select the database in the source SQL server instance which you would like to migrate.

azM6

Please note that the maximum number of instance which is currently supported in the Azure SQL Managed instance is 100.

In the next step you need to select the SQL logins

azM7

And the 5th step you need to configure the migration settings as you can see below

azM8

One of the important thing here is to create a storage account with SAS URI and provide the SAS token in the URL as you can see below

azM9

Once everything is completed the migration settings should look like the following.

azM10

As you can see above I got a validation error since the backup of the source SQL server database was not present in the above location.

The error is showing here.

azM11

Once I bypass that error by keeping backup of the SQL server, the next step is follows

azM12

In the next step, I ran the migration as you can see below

azM13

In the final step, you can see the status of the migration

azM14

After some time you can find the status as follows

azM15

After some time, you can see that the migration is completed. For more details, you can check the migration report.

azM16

That’s all about the migration of SQL databases from Azure IAAS or On-Premises SQL server instance to Azure SQL Managed instance with the help of Data Migration Tool. I hope you have liked this post. Stay tuned for more posts similar to this in the future.

Have a great day ahead.