DistributionSubscription Object (SQL-DMO)

The DistributionSubscription object exposes the properties of subscription to a publication maintained by a Distributor.

Remarks

For snapshot and transactional replication, a replication Distributor maintains an image of articles defining a publication. The Distributor replicates the articles to Subscribers, enabling one type of replication load balancing.

There is no requirement that a Microsoft® SQL Server™ installation create Distributor-maintained data images. Snapshot and transactional replication publications created on the Distributor enable one type of third-party, or heterogeneous, replication.

With the DistributionSubscription object, you can:

• Create a Distributor-originated (push) subscription to a heterogeneous replication publication.
• Enable or disable a subscription to a publication maintained by the Distributor.
• Remove a push subscription to a heterogeneous replication publication.

For more information about using SQL-DMO in heterogeneous replication, see Programming Transactional and Snapshot Replication from Heterogeneous Data Sources.

Note DistributionSubscription object properties are read/write only when using the object to create a subscription. When a DistributionSubscription object references a Distributor’s image of an existing subscription, all properties are read-only.

Methods

Properties