what's the difference between peer-to-peer vs merge replication

sakuraime 2,316 Reputation points
2021-11-02T08:57:08.757+00:00

what's the difference between peer-to-peer vs merge replication in sql server ?
both support multiple node write .

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,642 questions
0 comments
Accepted answer
  1. Andreas Kreuzberg 96 Reputation points
    2021-11-02T09:08:17.307+00:00

    Hi,
    I just used google:

    The main difference is that for merge replication there is only one publisher and one or more subscribers, but in peer-to-peer replication all nodes are both publishers and subscribers

    I hope that will help you.

    Kind regards,

    Andreas

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,301 Reputation points
    2021-11-03T08:41:08.197+00:00

    Peer-to-peer is based on the transaction log, it is transactional replication where all are both publishers as subscribers. Basically "chaos", although there is conflict detection and in the very last CU for SQL 2019 also "last one wins" option.

    Merge is based on triggers which fires when data is modified and reflect those modifications in your database, Then the merge agent uses that info to perform the modifications on the other "node" when it does the merge. this includes conflict detection and resolution.