what's the difference between peer-to-peer vs merge replication in sql server ?
both support multiple node write .
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.
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.
14 people are following this question.