Push vs. Pull

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  October 30, 2002 at 8:48 am

  #101290

  I have a situation where I what to move some historical type information from a number of servers to a central repository. I have one working now as Push replication to the central server.

  My question is

  Why would I choose Push versus Pull ?

  What are the +'s / -'s of one versus the other ?

  Movement of the data in this situation is not critical and only occurs a couple of times a day from each server, I'm not even concerned if I missed an occasional update.

  KlK, MCSE

  
  KlK

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 30, 2002 at 9:43 am

  #439823

  I like push because it keeps it all in one place. Advantage of pull is you offload the processing (or some of it anyway) to the other server/client.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter