Home Forums SQL Server 2005 SS2K5 Replication Should I chain replication, or use multiple subscribers of the same publication? RE: Should I chain replication, or use multiple subscribers of the same publication?

  • I believe that transactional replication is the only mode that allows peer to peer replication for chaining, but I'm not sure that would give what you are wanting. I don't think it would allow you to have a separate publication on the initial subscriber with different article filters, just a continuation of the same publication (so the same). I could be wrong though as most of my experience is with merge replication (which does not unfortunately support peer to peer).