Bi-directional replication modification

  • Hi,

      does anyone know if its possible to set up a bi-directional transactinal replication  with server A and B such that A push rep to B and A pull sub from B. The reason i wanted to do this is to have control on replication at A only.

  • Did you consider Merge replication?

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

  • tested merge, but the latency was not acceptable. so decided on bi-directional transactional replication. I tried to use the steps given in msn kb "How to implement bidirectional Transactional Replication" but it is using 2 push. I would like to have more control at the schedule to synchronize. Hence the push and pull subscriptions. Any idea if its possible to implement both type of subscriptions?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply