Merge replication is used to replicate data from a publisher to a subscriber database and vice-versa.
When a transaction occurs at the Publisher or Subscriber, the change is written to change tracking tables. The Merge Agent checks these tracking tables and sends the transaction to the distribution database where it gets propagated.
The merge agent has the capability of resolving conflicts that occur during data synchronization.
Part 1 : Introduction to Replication
• Replication in SQL server - Part 1 ||...
Part 2 : Snapshot Replication
• Replication in SQL server - Part 2 ||...
Part 3 : Transactional Replication
• Replication in SQL server - Part 3 ||...
Part 4 : Peer to Peer Replication
• Replication in SQL server - Part 4 ||...