Jaa

ReplicationDatabase Object

  • Artikkeli

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.

See Also

Reference

ReplicationDatabase2 Object

Help and Information

Getting SQL Server 2005 Assistance