How to Create a Pull Subscription (Transact-SQL)

How to Create a Pull Subscription (Transact-SQL)

To add a pull subscription to a snapshot publication

1. Execute sp_addpublication with allow_pull set to true to enable pull subscriptions at the Publisher.
   
   
2. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
3. Execute sp_addsubscription to create the subscription at the Publisher.
   
   
4. Execute sp_addpullsubscription to create the pull subscription at the Subscriber.
   
   
5. Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.

To create a pull subscription (transactional)

1. Execute sp_addpublication with allow_pull set to TRUE to enable pull subscriptions at the Publisher.
   
   
2. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
3. Execute sp_addsubscription to create the subscription at the Publisher.
   
   
4. Execute sp_addpullsubscription to create the pull subscription at the Subscriber.
   
   
5. Execute sp_addpullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.

To add a pull subscription (merge)

1. Execute sp_addmergepublication with allow_pull set to TRUE to enable pull subscriptions at the Publisher.
   
   
2. Execute sp_addsubscriber to register the Subscriber at the Publisher.
   
   
3. Execute sp_addmergesubscription to create the subscription at the Publisher.
   
   
4. Execute sp_addmergepullsubscription to create the subscription at the Subscriber.
   
   
5. Execute sp_addmergepullsubscription_agent to create a scheduled job for the Distribution Agent at the Subscriber.