Push vs. Pull

  • 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

  • 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/

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply