How to sync SQL databases from one region to another region?

Lakshmi Narayanan 71 Reputation points
2021-08-25T05:57:47.627+00:00

HI,

I have two SQL Database servers in two regions. Can i sync from one database to another database across regions? I had a look at the SQL Databases. I tried to use sync other databases with existing databases. But it listing Databases which are available in same region Databases.
126225-syncdb.png

Cant we sync database from one region DB to another region DB. For ex: I have SQL databases in north central US and one more SQL database in south central US. So i would like to sync from north central US DB to south central US DB. How to achieve this requirement?

Is there any option to achieve ? DB sync should happen regularly like per hour.

Azure SQL Database
{count} votes

Accepted answer
  1. Anurag Sharma 17,576 Reputation points
    2021-08-25T08:12:34.63+00:00

    Hi @Lakshmi Narayanan , welcome to Microsoft Q&A forum.

    SQL Data sync can sync across regions. I think what you are trying to do is creating a sync group which creates a Sync Metadata in same region. This database is not the member database. "The Sync Metadata Database contains the metadata and log for Data Sync. The Sync Metadata Database has to be an Azure SQL Database located in the same region as the Hub Database. The Sync Metadata Database is customer created and customer owned. You can only have one Sync Metadata Database per region and subscription. Sync Metadata Database cannot be deleted or renamed while sync groups or sync agents exist. Microsoft recommends to create a new, empty database for use as the Sync Metadata Database. Data Sync creates tables in this database and runs a frequent workload."

    After we create the sync group, then we configure the member database where we want to sync from the Hub database and it could be in any region. Please check the screenshots below:

    Sync group created:
    126229-image.png

    Click on sync group, we land on to this screen:

    126250-image.png

    Then we click on database and configure member database:

    126136-image.png

    Then we can select azure sql server across other locations as well:

    126137-image.png

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

    ----------

    If answer helps, you can mark it 'Accept Answer'


0 additional answers

Sort by: Most helpful