MergePullSubscription Object (SQL-DMO)

The MergePullSubscription object represents a Subscriber-initiated pull or anonymous subscription to a merge publication.

Remarks

With the MergePullSubscription object, you can:

To create a merge pull subscription at the Subscriber

  1. Create a new MergePullSubscription object.
  2. Set the Publisher property to the name of an existing Publisher.
  3. Set the PublicationDB property to the name of the database (at the Publisher) where the publication is located.
  4. Set the Publication property to the name of the publication to which to subscribe.
  5. Set the SubscriberType property to SQLDMOMergeSubscriber_Global or SQLDMOMergeSubscriber_Local.
  6. Set the SecurityMode property of the DistributorSecurity object property as appropriate.
  7. If the SecurityMode property of the DistributorSecurity object property is set to SQLDMOReplSecurity_Normal, set the StandardLogin and StandardPassword properties of the DistributorSecurity object property.
  8. Set the SecurityMode property of the PublisherSecurity object property as appropriate.
  9. If the SecurityMode property of the PublisherSecurity object property is set to SQLDMOReplSecurity_Normal, set the StandardLogin and StandardPassword properties of the PublisherSecurity object property.
  10. Note that the Name property defaults to publisher:publication_database:publication.
  11. Add the MergePullSubscription object to the MergePullSubscriptions collection of a connected ReplicationDatabase object at the Subscriber.
  12. Get a ReplicationDatabase object that contains the publication from the ReplicationDatabases collection of the Replication object that is connected to the Publisher.
  13. Use the EnableMergeSubscription method of the ReplicationDatabase object that is connected to the Publisher.

To alter an existing merge pull subscription at the Subscriber

  1. Get a MergePullSubscription object from the MergePullSubscriptions collection of a connected ReplicationDatabase object at the Subscriber.
  2. Use the BeginAlter method to mark the beginning of the changes.
  3. Set the MergePullSubscription object properties to reflect the changes to the merge pull subscription.
  4. Use the DoAlter method to submit the changes to Microsoft® SQL Server™.

To create a merge anonymous subscription at the Subscriber

  1. Create a new MergePullSubscription object.
  2. Set the Publisher property to the name of an existing Publisher.
  3. Set the PublicationDB property to the name of the database (at the Publisher) where the publication is located.
  4. Set the Publication property to the name of the publication to which to subscribe.
  5. Set the SubscriberType property to SQLDMOMergeSubscriber_Anonymous.
  6. Set the SecurityMode property of the DistributorSecurity object property as appropriate.
  7. If the SecurityMode property of the DistributorSecurity object property is set to SQLDMOReplSecurity_Normal, set the StandardLogin and StandardPassword properties of the DistributorSecurity object property.
  8. Set the SecurityMode property of the PublisherSecurity object property as appropriate.
  9. If the SecurityMode property of the PublisherSecurity object property is set to SQLDMOReplSecurity_Normal, set the StandardLogin and StandardPassword properties of the PublisherSecurity object property.
  10. Note that the Name property defaults to publisher:publication_database:publication.
  11. Add the MergePullSubscription object to the MergePullSubscriptions collection of a connected ReplicationDatabase object at the Subscriber.

To alter an existing merge anonymous subscription at the Subscriber

  1. Get a MergePullSubscription object from the MergePullSubscriptions collection of a connected ReplicationDatabase object at the Subscriber.
  2. Use the BeginAlter method to mark the beginning of the changes.
  3. Set the MergePullSubscription object properties to reflect the changes to the merge pull subscription.
  4. Use the DoAlter method to submit the changes to SQL Server.
Methods
BeginAlter Method ReInitialize Method
CancelAlter Method Remove Method (Objects)
DoAlter Method Script Method (Replication Objects)
EnumJobInfo Method  

Properties
Description Property Publication Property
Distributor Property PublicationDB Property
EnabledForSyncMgr Property Publisher Property
FTPAddress Property SubscriberLogin Property
FTPLogin Property SubscriberPassword Property
FTPPassword Property SubscriberSecurityMode Property
FTPPort Property SubscriberType Property (MergePullSubscription, MergeSubscription)
MergeJobID Property SubscriptionType Property
Name Property SyncType Property
Priority Property  

  


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