Share via

how to migrate on-prem sql 2019 databases to Azure SQL Server AAG env

SQLDev 96 Reputation points
2023-08-12T05:43:41.74+00:00

Hello, I have on-prem SQL Server 2019 databases. I want to migrate those on-prem databases to Azure SQL Server Alwayson AAG env which is in different domain. How can I migrate the on-prem SQL 2019 databases to that Azure SQL AAG environment which is in different domain? Any ideas please?

Thanks.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,690 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Javier Villegas 900 Reputation points MVP
    2023-08-12T15:52:05.2233333+00:00

    Hello.

    What do you mean migrate to Azure SQL AAG environment? are Virtual Machine in Azure ?

    if that's the case the best option is to use Distributed Availability Groups . Also you can do backup/restore (For Azure SQL VMs or Azure SQL Managed Instance)

    You can also use Azure Data Studio with Azure Migration Extension

    Regards

    Javier

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.