SQL Server with Mr. Denny

May 7 2009   11:00AM GMT

Pull vs. Push Subscriptions? Which one should you use?



Posted by: Denny Cherry
Tags:
Replication
SQL Server 2000
SQL Server 2005
SQL Server 2008

This is a “it depends” sort of question.

These are my recommendations, your mileage may vary.

Your distributor is on the same system as your publisher – Pull is probably for you

Your Subscribers are a very high transaction count – Push is probably for you

You need to manually copy the subscription over the network to the subscriber and load it up from the local drive – Pull is probably for you

Your distributor is on a separate from the publisher – Push is probably for you

The distributor is on the same server as your subscriber – Either, as the agent will be running on the distributor either way

You have a slow network link – Either, slow networks aren’t overcome with either technique

If you have specific’s you’d like to ask about, post your questions below, or in the ITKE forum.

Denny

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: