push or pull?
this is for transaction replication.
Kevin,
it depends

anonymous subscriptions can increase performance by moving Distribution
Agent processing from the Distributor to Subscribers.
On the other hand, push will centralize the agents for management purposes.
From BOL:
Use pull subscriptions when:
a.. Administration of the subscription will take place at the Subscriber.
b.. The publication has a large number of Subscribers (for example,
Subscribers using the Internet), and when it would be too resource-intensive
to run all the agents at one site or all at the Distributor.
c.. Subscribers are autonomous, disconnected, and/or mobile. Subscribers
will determine when they will connect to the Publisher/Distributor and
synchronize changes.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
No comments:
Post a Comment