DistributionArticle Object (SQL-DMO)

The DistributionArticle object exposes the properties of a Distributor’s image of a replicated article.

Remarks

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

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

With the DistributionArticle object, you can:

• Create an article in a heterogeneous replication publication.
• Remove an article from 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 DistributionArticle object properties are read/write only when using the object to create a distribution article. When a DistributionArticle object references a Distributor’s image of any replicated article, all properties are read-only.

Methods

Properties