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

Prince Kumar Rastogi 31 Reputation points
2021-03-29T15:00:29.647+00:00

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 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anurag Sharma 17,571 Reputation points
    2021-03-30T05:31:11.933+00:00

    Hi @Prince Kumar Rastogi , 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'

    1 person found this answer helpful.
    0 comments