共用方式為


ReplicationDatabase Object

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。

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

顯示目前物件的 SQL-DMO 物件模型

備註

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.

請參閱

參考