2 out of 4 rated this helpful - Rate this topic

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

SQL Server 2005

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.

Connect to the Publisher in Microsoft SQL Server Management Studio, and then expand the server node.
Expand the Replication folder, and then expand the Local Publications folder.
Right-click the publication for which you want to create one or more subscriptions, and then click New Subscriptions.
Complete the pages in the New Subscription Wizard.

Connect to the Subscriber in SQL Server Management Studio, and then expand the server node.
Expand the Replication folder.
Right-click the Local Subscriptions folder, and then click New Subscriptions.
On the Publication page of the New Subscription Wizard, select <Find SQL Server Publisher> or <Find Oracle Publisher> from the Publisher drop-down list.
Connect to the Publisher in the Connect to Server dialog box.
Select a publication on the Publication page.
Complete the pages in the New Subscription Wizard.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions