Migration of On-Prem SQL Servers to Azure

Question

Hello,

I have 2 On-prem SQL Servers (One is primary server and other is Secondary server). SQL version is 2016 and edition is Enterprise.

I have configured always-on for 10 big databases under multiple AAGs.

Now I want to migrate my both On-Prem SQL servers to either SQL Server in VM in Azure or SQL Managed Instance.

How can I achieve this without affecting my current always-on setup and with minimum downtime.

Please provide solutions for both scenario step by step (Considering destination as SQL Server in VM in Azure and SQL Managed Instance in Azure.)

Answer 1

Hi @Parth Mehta,

This article teaches you to migrate your SQL Server Always On availability group to SQL Server on Azure VMs using the Azure Migrate: Server Migration tool. Using the migration tool, you will be able to migrate each replica in the availability group to an Azure VM hosting SQL Server, as well as the cluster metadata, availability group metadata and other necessary high availability components.

Migrate an availability group to SQL Server on Azure VM

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Parth Mehta,

Migration from Always on Availablity group to SQL Server on Azure VMs shall be achieved using the Server Migration tool. Refer the following tutorial to understand how can you set up the same.

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/virtual-machines/sql-server-availability-group-to-sql-on-azure-vm?view=azuresql

For Azure SQL server Managed Instance, you are not required to migrate the Always on Availablity groups as high availability is built in. Refer the following migration guide that gives you all the details to assist you in the migration.

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide?view=azuresql

Hope this helps