all groups > sql server replication > june 2005 >
You're in the

sql server replication

group:

bi-directional transactional replication vs transactional replication with queued updating


Re: bi-directional transactional replication vs transactional replication with queued updating Hilary Cotter
6/7/2005 12:00:00 AM
sql server replication:
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
[quoted text, click to view]

bi-directional transactional replication vs transactional replication with queued updating William F. Kinsley
6/7/2005 1:10:25 PM
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


AddThis Social Bookmark Button