Sign in
 
Home20122008 R2200820052000LibraryForums
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
SQL Server >
> 
> 
With Merge Replication There Is Only One Distributor

Answered With Merge Replication There Is Only One Distributor

  • Tuesday, November 13, 2012 8:25 PM
     
     
    Sign In to Vote
    0

    Am I correct in saying that with Merge replication there is only one distributor. Why is that.

    Thanks,

     

All Replies

  • Tuesday, November 13, 2012 9:24 PM
    Moderator
     
     Answered
    Sign In to Vote
    1
    The reason for this is Merge uses triggers and tracking tables in the publication and subscription databases to synchronize changes between publisher and subscribers.  The distributor plays a smaller role in Merge compared to Transactional or Peer-to-Peer, only storing metadata and synchronization history.

    Brandon Williams (blog | linkedin)