Azure Data Sync is taking longer than Expected for data sync.

Raj, Ritu 0 Reputation points
2024-05-15T06:38:40.1433333+00:00

Hi Team,
I am doing POC for Bi-Directional data Sync using Azure Data Sync Approach. I am facing following Issues -

  1. The minimum time between each sync across databases is 5 seconds. Can this be minimized further.
  2. Assume we are bi-directionally syncing a table across databases in different regions. When same primary key value is created in both the databases from its respective sources, one record is overriding the other during sync. Please suggest if there is customized way of handling merge conflicts across databases in different regions wrt primary key.
Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,987 Reputation points Microsoft Employee
    2024-05-15T17:02:57.9266667+00:00

    @Raj, Ritu Thanks for posting your question on Microsoft Q&A forum.User's image

    No, we cannot minimize to 5 seconds. Data sync is never designed for real-time sync.

    User's image No, we do not have customized conflict resolution except hub win/member win.

    Regards

    Geetha