Estimated Reading Time: 2 minutes
As you are aware in my last post I have written about the first part of migrating a SQL database to SQL Managed instance with the help of Data Migration Service. The post you can read here.
Today 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.
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.
And in next step you need to give the source of the SQL Server instance from where you need to migrate the database.
Since the source server connection data I would like to encrypt during transit so I have selected this option
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
Now in next step you need to select the database in the source SQL server instance which you would like to migrate.
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
And the 5th step you need to configure the migration settings as you can see below
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
Once everything is completed the migration settings should look like the following.
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.
Once I bypass that error by keeping backup of the SQL server, the next step is follows
In the next step, I ran the migration as you can see below
In the final step, you can see the status of the migration
After some time you can find the status as follows
After some time, you can see that the migration is completed. For more details, you can check the migration report.
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.