Push or Pull replication

What is better to use, Push or Pull Replication? What are the advantages and disadvantages?

It really depends on your environment.

Check out this article,

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx

Here is some advantage using pull subscription:

Using Pull Subscriptions

The Distribution Agent runs on the Distributor for push subscriptions and on Subscribers for pull or anonymous subscriptions. Using pull or anonymous subscriptions can increase performance by moving Distribution Agent processing from the Distributor to Subscribers.

Anonymous subscriptions, which are especially useful for Internet applications, do not require information about the Subscriber to be stored in the distribution database at the Distributor for transactional replication. Not having to maintain information on Subscribers using anonymous subscriptions reduces the resource demands on the Publisher and Distributor.

Anonymous subscriptions are a special category of pull subscriptions. In regular pull subscriptions, the Distribution Agent runs at the Subscriber (thereby reducing the resource demands on the Distributor), but it still stores information at the Publisher.

However, since pull subscription is managed on the subscriber, so if you have many subscribers with different sync schedule, there maybe more administrative overhead.

Gary

sql