ReplicationDatabase Object

SQL-DMO

previous page next page

SQL-DMO

ReplicationDatabase Object

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

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.

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.

Note The ReplicationDatabase object is compatible with instances of Microsoft® SQL Server™ 2000 and SQL Server version 7.0. However, the ReplicationDatabase2 object extends the functionality of the ReplicationDatabase object for use with features that are new in SQL Server 2000.

ReplicationDatabase Object

SQL-DMO