How to move a Database from one Azure SQL Managed Instance to another Azure SQL Managed Instance.

In Azure SQL Managed Instance we have the option to move the database between Azure SQL Managed Instances. It is quite simple to move the database from one SQL managed instance to another SQL managed instance. In this article we will see how to move or copy an sql managed instance database from one azure sql managed instance to another azure sql managed instance.

 

Login to the Azure portal and search for SQL managed instance.

 

Click on the SQL managed instance and the database inside the managed instance which you want to move. Here I have only one sample database named ‘WideWorldImporters’ once you click on the database you should see an overview page like below

on the Overview page you can see several options and among them, there are 2 options COPY and MOVE. Copy is to copy the database to another subscription by keeping the original database in its source and move will move the database from the source location to the destination location.

 

 

Now click on copy and we should see a similar page like below. 

 

Here we can see source details like the source database, resource group, source sql managed instance name. After verifying all details Click on 'Next: Destination details' button.

Here we need to provide the destination resource group and the SQL managed instance.

 

After that once we click on ‘Review+Start’ the copy process will start and if any errors pop up we need to remediate those before copying can start.

 

Similarly, we can also move the database by clicking on the MOVE button and selecting source and destination SQL managed instances and their respective resource groups and click on Review+Create as shown in below pictures.

 

 

Thanks VV!!

#sqlmanagedinstance #azure #azuresql #azurearchitect #cloudarchitect