MergeSubscription Object (SQL-DMO)

The MergeSubscription object represents a push subscription (made from the Publisher) to a merge publication.

Remarks

With the MergeSubscription object, you can:

To create a merge push subscription at the Publisher

  1. Create a new MergeSubscription object.
  2. Set the Subscriber property to the name of an existing Subscriber.
  3. Set the SubscriptionDB property to the name of the database (at the Subscriber) where the subscription data will be stored.
  4. Note that the Name property defaults to subscriber:subscription_database.
  5. Add the MergeSubscription object to the MergeSubscriptions collection of a connected MergePublication object.

To alter an existing merge push subscription

  1. Get a MergeSubscription object from the MergeSubscriptions collection of a connected MergePublication object.
  2. Use the BeginAlter method to mark the beginning of the changes.
  3. Set the MergeSubscription object properties to reflect the changes to the merge push subscription.
  4. Use the DoAlter method to submit the changes to Microsoft® SQL Server™.
Methods
BeginAlter Method ReInitialize Method
CancelAlter Method Remove Method (Objects)
DoAlter Method Script Method (Replication Objects)

Properties
Description Property Subscriber Property
EnabledForSyncMgr Property SubscriberType Property (MergePullSubscription, MergeSubscription)
MergeJobID Property SubscriptionDB Property
Name Property SubscriptionType Property
Priority Property SyncType Property
Status Property (Subscription Objects)  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.