question

princerastogi avatar image
0 Votes"
princerastogi asked AnuragSharma-08 commented

Migrate/Copy Online - Azure SQL Database to different Azure SQL Server in another resource group

We have a scenario, where we want to migrate existing azure SQL database to another azure SQL Server/Azure SQL DB in another resource group without any application downtime or as much minimum as possible.

I have found few ways but those are not fulfilling my requirements:

  1. DMS - can not use Azure SQL DB as source

  2. Powershell: Can only create snapshot at a point in time.

is there any possible way?

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @princerastogi, just wanted to follow up on this thread. Please let us know if you need any other details.

0 Votes 0 ·

1 Answer

AnuragSharma-08 avatar image
0 Votes"
AnuragSharma-08 answered

Hi @princerastogi, welcome to Microsoft Q&A forum.

There could be few ways as listed below for migration from one Azure SQL db to another.

  1. Azure Data Sync: Using this service you can sync the data between multiple Azure SQL Database.
    SQL Data Sync

  2. Bacpac file: You can export bacpac from one Azure SQL DB and import it to another.
    Export Bacpac
    Import Bacpac

  3. Using Azure Data Factory: You can use ADF to copy to and from Azure SQL Database to another.
    Copy and transform data in Azure SQL Database

Please let me know if this helps or we can discuss further.


If answer helps, please mark it as 'Accept Answer'




5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.