In what scenario should I choose SQL Data Sync and why not Transactional Replication?

SebastianMarkov 41 Reputation points
2023-02-22T05:56:26.6066667+00:00

In what scenario should I choose SQL Data Sync and why not Transactional Replication?

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. SSingh-MSFT 16,371 Reputation points Moderator
    2023-02-22T08:44:58.84+00:00

    Hi @SebastianMarkov ,

    Welcome to Microsoft Q&A forum and thanks for using Azure services.

    As I understand from the question, you want to know the scenario when we can choose SQL Data Sync and how it is different from Transactional Replication.

    SQL Data Sync can be used for the below use cases:

    • Hybrid Data Synchronization: With Data Sync, you can keep data synchronized between your databases in SQL Server and Azure SQL Database 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/regions. 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.

    Transactional Replication and SQL Data Sync comparison is given below:

    User's image

    Reference: compare-with-transactional-replication

    Demonstration video for SQL Data Sync: SQL Data Sync | Demo of Data Sync with Hub and Member as Azure SQL Database | Data Synchronization

    Hope this helps. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.