Sunday, March 11, 2012

bi-directional transactional replication vs transactional replication with queued updating

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
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
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"William F. Kinsley" <bacardi@.noemail.nospam> wrote in message
news:OABBHP4aFHA.2860@.TK2MSFTNGP10.phx.gbl...
> 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
>
>

No comments:

Post a Comment