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. William F. Kinsley

    William F. Kinsley Guest

    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. William F. Kinsley

    Hilary Cotter Guest

    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.
Similar Threads

  1. Immediate Updating with Queued Updating as a Failover - Error

  2. Schema changes WITHOUT REINITIALIZING in Transactional Replication with Queued Updating

  3. Deadlocking issues with queued updating transactional replication

  4. Role of Distributors in transactional replication with queued updating

  5. Transactional Replication with queued updating

  6. Error in queued transactional updating replication - could not find stored procedure "upd. ...

  7. Transactional with queued updating replication-problem

  8. Transactional Replication with Queued Updating Error ?

Loading...