Using the Push and Pull Subscription Wizards

The Push Subscription Wizard and the Pull Subscription Wizard help you create subscriptions to publications.

Push Subscription Wizard

You can use the Push Subscription Wizard  to create one or more push subscriptions to each publication on a Publisher. Using the wizard, you can specify:

• One or more servers or server groups to receive the publication as Subscribers.
• The destination database, which must exist on all Subscribers.
• Subscription properties.

You must be a member of the sysadmin or db_owner roles to set up a push subscription. However, before creating the push subscription, a member of the sysadmin role must register the Subscribers. Other tasks must also be performed before the subscription can be created:

• Create the publication
• Create a destination database at each subscribing server

  If selecting more than one server or server group, use the same destination database name at each Subscriber.

Pull Subscription Wizard

Using the Pull Subscription Wizard, you can specify:

• The publication to which you want to subscribe.
• The name of the destination database to be used for the subscription.
• Subscriber properties, such as the synchronization schedule with the Publisher, the visibility of the subscription to other Subscribers, whether the subscription can update data, and what priority each Subscriber has when there is a conflict of changes.

To start the Push Subscription Wizard

To start the Pull Subscription Wizard