What is the difference between Push and Pull Subscription?

1.	What is the difference between Push and Pull Subscription?
Answer» Push &AMP; Pull is a type of Replication configuration. It decides how data will be replicated to the SUBSCRIBER. Push – In Push subscription, the publisher is responsible for sending data. Publisher pushes data from the publisher to the subscriber. Distributor agent will run on the Distributor to push changes. The distributor can be CONFIGURED on the Publisher or separate server. Changes can be pushed to subscribers on demand, continuously, or on a scheduled basis. Pull is best suited configured when the subscriber is connected all the time and need the latest data all the time accessed. Pull - In Pull subscription, Subscribers is responsible for FETCHING data. Subscribers requests changes from the Publisher. Distributor agent will run on the subscriber to Pull changes. The subscriber can pull data as & when needed. Pull is best suited when subscribers are not online every time. The subscriber can allow data lag and can wait for delay in data REFRESH

Answer»

Push &AMP; Pull is a type of Replication configuration. It decides how data will be replicated to the SUBSCRIBER.

Push – In Push subscription, the publisher is responsible for sending data. Publisher pushes data from the publisher to the subscriber. Distributor agent will run on the Distributor to push changes. The distributor can be CONFIGURED on the Publisher or separate server. Changes can be pushed to subscribers on demand, continuously, or on a scheduled basis.

Pull is best suited configured when the subscriber is connected all the time and need the latest data all the time accessed.

Pull - In Pull subscription, Subscribers is responsible for FETCHING data. Subscribers requests changes from the Publisher. Distributor agent will run on the subscriber to Pull changes. The subscriber can pull data as & when needed.

Pull is best suited when subscribers are not online every time. The subscriber can allow data lag and can wait for delay in data REFRESH

Discussion