Article
05/23/2011

ReplicationDatabase Object

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The ReplicationDatabase object represents a user database that can participate in replication.

SQL-DMO object model that shows the current object

Properties

AllowMergePublication Property	EnableTransPublishing Property
DBOwner Property	Name Property
EnableMergePublishing Property

Methods

DisableMergeSubscription Method	EnumConflictTables Method
DisableTransSubscription Method	EnumInitialAccesses Method
EnableMergeSubscription Method	RefreshChildren Method
EnableTransSubscription Method	Script Method (Replication Objects)

Remarks

With the ReplicationDatabase object, you can:

Enable and disable transactional publishing.
Enable and disable merge publishing.
Note The ReplicationDatabase object is compatible with instances of Microsoft SQL Server versions 7.0 and later. However, the ReplicationDatabase2 object extends the functionality of the ReplicationDatabase object for use with features that were introduced in SQL Server 2000.

To enable transactional publishing for a database

Set the EnableTransPublishing property of a connected ReplicationDatabase object to TRUE.

To disable transactional publishing for a database

Set the EnableTransPublishing property of a connected ReplicationDatabase object to FALSE.

To enable merge publishing for a database

Set the EnableMergePublishing property of a connected ReplicationDatabase object to TRUE.

To disable merge publishing for a database

Set the EnableMergePublishing property of a connected ReplicationDatabase object to FALSE.