Pull or Push subscription in Merge replication

I have 2 identical systems in my LAN. I want to set up merge replication between these. I am bit confused among PULL or PUSH subscriptions.
Gurus can you suggest me best option
Regards
Javed
"Javed Iqbal" schrieb:
> I have 2 identical systems in my LAN. I want to set up merge replication between these. I am bit confused among PULL or PUSH subscriptions.
> Gurus can you suggest me best option
> Regards
> Javed
In push subscriptions the distributor agent runs on the distributor, in pull
subscriptions it runs on (each) subscriber.
Use push if
1. the central publisher must control the timing for the data synchronization.
2. the distributor server has enough resources to run the extra agent.
Use pull if
1. the subscribers must decide the timing for the data synchronization (e.g.
Laptops that are not always connected to the network or avoiding data
synchronization during extensive batch processes)
2. the distributor is performing badly or low on resources.
|||Thanks Christian
Regards
Javed
"Christian Donner" <ChristianDonner@.discussions.microsoft.com> wrote in
message news:87D4A071-F04F-4910-A27F-3D915C786DAD@.microsoft.com...[vbcol=seagreen]
> "Javed Iqbal" schrieb:
between these. I am bit confused among PULL or PUSH subscriptions.
> In push subscriptions the distributor agent runs on the distributor, in
pull
> subscriptions it runs on (each) subscriber.
> Use push if
> 1. the central publisher must control the timing for the data
synchronization.
> 2. the distributor server has enough resources to run the extra agent.
> Use pull if
> 1. the subscribers must decide the timing for the data synchronization
(e.g.
> Laptops that are not always connected to the network or avoiding data
> synchronization during extensive batch processes)
> 2. the distributor is performing badly or low on resources.
|||also use pull if you have a large number of subscribers.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Christian Donner" <ChristianDonner@.discussions.microsoft.com> wrote in
message news:87D4A071-F04F-4910-A27F-3D915C786DAD@.microsoft.com...[vbcol=seagreen]
> "Javed Iqbal" schrieb:
between these. I am bit confused among PULL or PUSH subscriptions.
> In push subscriptions the distributor agent runs on the distributor, in
pull
> subscriptions it runs on (each) subscriber.
> Use push if
> 1. the central publisher must control the timing for the data
synchronization.
> 2. the distributor server has enough resources to run the extra agent.
> Use pull if
> 1. the subscribers must decide the timing for the data synchronization
(e.g.
> Laptops that are not always connected to the network or avoiding data
> synchronization during extensive batch processes)
> 2. the distributor is performing badly or low on resources.