How to add a merge pull subscription (Transact-SQL)

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.

See Also