What are the data synchronize services in Azure?

What are the data synchronize services in Azure?

Asked on November 13, 2018 in Database.
Add Comment


  • 3 Answer(s)

        SQL Data Sync is a service built on Azure SQL Database that lets you synchronize the data you select bidirectionally across multiple SQL databases and SQL Server instances.

        Data Sync is based around the concept of a Sync Group. A Sync Group is a group of databases that you want to synchronize.

        A Sync Group has the following properties:

    • The Sync Schema describes which data is being synchronized.
    • The Sync Direction can be bi-directional or can flow in only one direction. That is, the Sync Direction can be Hub to Member or Member to Hub, or both.
    • The Sync Interval is how often synchronization occurs.
    • The Conflict Resolution Policy is a group level policy.

        Data Sync uses a hub and spoke topology to synchronize data. The rest of the databases are member databases. Sync occurs only between the Hub and individual members.

    • The Hub Database must be an Azure SQL Database.
    • The member databases can be either SQL Databases, on-premises SQL Server databases, or SQL Server instances on Azure virtual machines.
    • The Sync Database contains the metadata and log for Data Sync. It will be an Azure SQL Database located in the same region as the Hub Database. It is a customer created and customer owned database.
    Answered on November 13, 2018.
    Add Comment

    Data Sync is useful in cases where data needs to be kept up-to-date across several Azure SQL databases or SQL Server databases. Here are the main use cases for Data Sync:

    • Hybrid Data Synchronization: With Data Sync, you can keep data synchronized between your on-premises databases and Azure SQL databases to enable hybrid applications. This capability may appeal to customers who are considering moving to the cloud and would like to put some of their application in Azure.
    • Distributed Applications: In many cases, it’s beneficial to separate different workloads across different databases. For example, if you have a large production database, but you also need to run a reporting or analytics workload on this data, it’s helpful to have a second database for this additional workload. This approach minimizes the performance impact on your production workload. You can use Data Sync to keep these two databases synchronized.
    • Globally Distributed Applications: Many businesses span several regions and even several countries. To minimize network latency, it’s best to have your data in a region close to you. With Data Sync, you can easily keep databases in regions around the world synchronized.

    A Sync Group has the following properties:

    • The Sync Schema describes which data is being synchronized.
    • The Sync Direction can be bi-directional or can flow in only one direction. That is, the Sync Direction can be Hub to Member, or Member to Hub, or both.
    • The Sync Interval describes how often synchronization occurs.
    • The Conflict Resolution Policy is a group level policy, which can be Hub wins or Member wins
    Answered on January 14, 2019.
    Add Comment
    Dimensions Limit Workaround
    Maximum number of sync groups any database can belong to. 5
    Maximum number of endpoints in a single sync group 30
    Maximum number of on-premises endpoints in a single sync group. 5 Create multiple sync groups
    Database, table, schema, and column names 50 characters per name
    Tables in a sync group 500 Create multiple sync groups
    Columns in a table in a sync group 1000
    Data row size on a table 24 Mb
    Minimum sync interval 5 Minutes
    Answered on February 20, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.