Push Subscription Wizard, Welcome
The Welcome page of the Create Push Subscription Wizard includes a description of the Create Push Subscription Wizard and an option to select advanced options during the wizard.
If you enable Show advanced options in this wizard and you create a push subscription for a snapshot or transactional publication, you will be able to configure the subscription for:
- Updatable subscription options for immediate updating and/or queued updating.
- Running the agent at a location other than the Distributor.
When creating a push subscription to a merge publication, you will see all the options available whether the Show advanced options in the wizard check box is selected or not.
Updatable Subscriptions
Typically, replicated data is read-only. However, in SQL Server™ 2000, you have the ability to modify replicated data at the Subscriber by using updatable subscriptions with snapshot replication or transactional replication or by using merge replication. If you need to modify data at the Subscriber using snapshot replication or transactional replication, you can choose immediate updating, queued updating or immediate updating with queued updating as a failover.
For more information, see Updatable Subscriptions.
Remote Agent Activation
Remote agent activation allows you to reduce the amount of processing on the Distributor or Subscriber by running the Distribution Agent or Merge Agent on another computer and then activating that agent remotely using Distributed Component Object Model (DCOM).
You can implement remote agent activation on either push or pull subscriptions. With each type of subscription, you need to:
- Indicate where the agent will run in the Push Subscription or Pull Subscription Wizard.
- Configure DCOM to activate an agent remotely.
- Configure or create the subscription indicating where the agent should run.