How to: Create a Push Subscription (SQL Server Management Studio)

Create a push subscription at the Publisher or the Subscriber using the New Subscription Wizard. Follow the pages in the wizard to:

  • Specify the Publisher and publication.
  • Select where replication agents will run. For a push subscription, select Run all agents at the Distributor (push subscriptions) on the Distribution Agent Location page or Merge Agent Location page, depending on the type of publication.
  • Specify Subscribers and subscription databases.
  • Specify the logins and passwords used for connections made by replication agents:
    • For subscriptions to snapshot and transactional publications, specify credentials on the Distribution Agent Security page.
    • For subscriptions to merge publications, specify credentials on the Merge Agent Security page.
      For information about the permissions required by each agent, see Replication Agent Security Model.
  • Specify a synchronization schedule and when the Subscriber should be initialized.
  • Specify additional options for merge publications: subscription type; and values for parameterized filtering.
  • Specify additional options for transactional publications that allow updating subscriptions: whether Subscribers should commit changes at the Publisher immediately or write them to a queue; credentials used to connect from the Subscriber to the Publisher.
  • Optionally script the subscription.

For information about creating a push subscription for a non-SQL Server Subscriber, see How to: Create a Subscription for a Non-SQL Server Subscriber (SQL Server Management Studio).

To create a push subscription from the Publisher

  1. Connect to the Publisher in Microsoft SQL Server Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Right-click the publication for which you want to create one or more subscriptions, and then click New Subscriptions.

  4. Complete the pages in the New Subscription Wizard.

To create a push subscription from the Subscriber

  1. Connect to the Subscriber in SQL Server Management Studio, and then expand the server node.

  2. Expand the Replication folder.

  3. Right-click the Local Subscriptions folder, and then click New Subscriptions.

  4. On the Publication page of the New Subscription Wizard, select <Find SQL Server Publisher> or <Find Oracle Publisher> from the Publisher drop-down list.

  5. Connect to the Publisher in the Connect to Server dialog box.

  6. Select a publication on the Publication page.

  7. Complete the pages in the New Subscription Wizard.

See Also

Tasks

How to: View and Modify Push Subscription Properties (SQL Server Management Studio)
How to: Configure Peer-to-Peer Transactional Replication (SQL Server Management Studio)

Concepts

Replication Security Best Practices
Subscribing to Publications

Other Resources

How to: Create a Push Subscription (Replication Transact-SQL Programming)

Help and Information

Getting SQL Server 2005 Assistance