push vs pull replication

[katgirl]

Can someone please clarify the benefits of push vs pull replication

and

pull vs push replication?

The reason I ask is, the other dba couldn't get pull replication to work here, but got push replication working... so now he says push is better because it won't put load on our main server. I don't want this to be the reason we choose push over pull, because we couldn't get pull working.

On the other hand, I've read that pull replication is better (in some circumstances).

Thanks

 

[mrdenny]

The basic difference is what server is starting the connection. I generally use push replication so that I can control everything from one place. If the subscriber needs to be in a remote site then I'd recommend using pull replication so that the subscriber can control the connecting to the publisher and distributor..

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com