bi-directional transactional replication vs transactional replication with queued updating

Discussion in 'microsoft.public.sqlserver.replication' started by William F. Kinsley, Jun 7, 2005.

  1. Can someone help me understand the what the differences are between the
    different types of bi-directional transactional replication, i.e
    1) bi-directional transactional replication
    2) transactional replication with queued updating,

    Thanks
     
    William F. Kinsley, Jun 7, 2005
    #1
    1. Advertisements

  2. Bi-Directional replication is when a subscriber publishes back to the
    publisher. You can only do this between two nodes, ie one publisher
    subscriber pair. You need to partition carefully to minimize conflicts.

    Queued updating using a queue (a SQL Server table or MSMQ). You can scale up
    to about 10 clients - performance is not good after this. Queued updating
    uses triggers on the subscriber and a tracking column.

    HTH
     
    Hilary Cotter, Jun 7, 2005
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.