ReplicationDatabase 成員
Represents a publication or subscription database in a replication topology.
ReplicationDatabase 型別公開下列成員。
建構函式
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
ReplicationDatabase() () () () | Initializes a new instance of the ReplicationDatabase class. |
|
ReplicationDatabase(String, ServerConnection) | Initializes a new instance of the ReplicationDatabase class with the specified database name, providing a connection to the server on which the database exists. |
頂端
方法
| 名稱 | 描述 | |
|---|---|---|
.gif "受保護的方法") |
CheckValidCreation | 基礎結構。 (繼承自 ReplicationObject。) |
|
CheckValidDefinition | 基礎結構。 (繼承自 ReplicationObject。) |
|
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (繼承自 ReplicationObject。) |
|
CreateLogReaderAgent | Creates a Log Reader Agent job for a database published with transactional replication. |
|
CreateQueueReaderAgent | Creates a Queue Reader Agent job for the distribution database. |
|
Decouple | Decouples the referenced replication object from the server. (繼承自 ReplicationObject。) |
|
EnumConflictTables | Returns conflict information for all merge publications and subscriptions that use the replication database. |
|
EnumMergeConflictCounts | Returns information on conflicts stored in a merge publication or subscription database. |
|
EnumMergePublications | Returns a list of merge publications that use the replication database. |
|
EnumMergePullSubscriptions | Returns all merge pull subscriptions that use this replication database. |
|
EnumPublicationArticles | Returns replication information for published objects in the replication database. |
|
EnumReplicationSchemaBoundViews | Returns all user-defined schema-bound view objects in the database. |
|
EnumReplicationStoredProcedures | Returns all user-defined stored procedure objects in the database. |
|
EnumReplicationTables | Returns all user-defined table objects in the database. |
|
EnumReplicationUserDefinedAggregates | Returns a list of user-defined aggregates in the database. |
|
EnumReplicationUserDefinedFunctions | Returns a list of user-defined functions in the database. |
|
EnumReplicationViews | Returns a list of the user-defined views objects in the database. |
|
EnumTransConflictCounts | Returns information on conflicts stored in an updating transactional publication or subscription database. |
|
EnumTransPublications | Returns a list of transactional and snapshot publications that use the database. |
|
EnumTransPullSubscriptions | Returns a list of transactional and snapshot pull subscriptions that use the database. |
|
Equals | (繼承自 Object。) |
|
Finalize | (繼承自 Object。) |
|
GetChangeCommand | 基礎結構。 (繼承自 ReplicationObject。) |
|
GetCreateCommand | 基礎結構。 (繼承自 ReplicationObject。) |
|
GetDropCommand | 基礎結構。 (繼承自 ReplicationObject。) |
|
GetHashCode | (繼承自 Object。) |
|
GetType | (繼承自 Object。) |
|
InternalRefresh | 基礎結構。 (繼承自 ReplicationObject。) |
|
LinkPublicationForUpdateableSubscription | Sets the configuration and security information used by synchronization triggers of updatable subscriptions when connecting to the Publisher. |
|
Load | Loads the properties of an existing object from the server. (繼承自 ReplicationObject。) |
|
LoadProperties | Loads the properties of an existing object from the server. (繼承自 ReplicationObject。) |
|
MemberwiseClone | (繼承自 Object。) |
|
ReadSubscriptionFailoverMode | Returns the failover mode for an updating subscription to a transactional or snapshot publication. |
|
Refresh | Reloads the properties of the object. (繼承自 ReplicationObject。) |
|
Script | Returns a Transact-SQL script to enable or disable replication publishing and subscriptions on the database based on the properties of ReplicationDatabase. |
|
ScriptReplicationDBOption | Returns a Transact-SQL script to enable or disable replication options on the database based on the properties of ReplicationDatabase. |
|
ToString | (繼承自 Object。) |
|
WriteSubscriptionFailoverMode | Sets the failover mode for an updating subscription to a transactional or snapshot publication. |
頂端
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
AllowMergePublication | Specifies whether or not the database can be published using merge replication. |
|
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (繼承自 ReplicationObject。) |
|
CompatibilityLevel | Gets the minimum version of SQL Server with which the database has compatible behavior. |
|
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (繼承自 ReplicationObject。) |
|
DBOwner | Gets if the login used by the current connection has ownership rights to the database. |
|
DBReadOnly | Gets whether the database is read-only or not. |
|
EnabledMergePublishing | Gets or sets whether the database is enabled for merge publishing or not. |
|
EnabledTransPublishing | Gets or sets whether the database is enabled for transactional or snapshot publishing or not. |
|
HasPublications | Gets whether or not the database has existing publications. |
|
HasPullSubscriptions | Gets whether or not the database has existing pull subscriptions. |
|
IsExistingObject | Gets whether the object exists on the server or not. (繼承自 ReplicationObject。) |
|
LogReaderAgentExists | Gets whether or not the Log Reader Agent has been created for the publication database. |
|
LogReaderAgentName | Gets the name of an existing Log Reader Agent or sets the name when creating a new Log Reader Agent for a published database. |
|
LogReaderAgentProcessSecurity | Gets the Microsoft Windows account under which the Log Reader Agent job runs at the Distributor. |
|
LogReaderAgentPublisherSecurity | Gets the login used by the Log Reader Agent to connect to the Publisher. |
|
MergePublications | Returns the merge publications defined on the replication database. |
|
MergePullSubscriptions | Returns the merge pull subscriptions defined on the replication database. |
|
Name | Gets or sets the name of the replication database. |
|
QueueReaderAgentExists | Gets whether or not a Queue Reader Agent job exists for the database. |
|
QueueReaderAgentProcessSecurity | Gets the Microsoft Windows account under which the Queue Reader Agent job runs at the Distributor. |
|
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (繼承自 ReplicationObject。) |
|
TransPublications | Returns the transactional or snapshot publications defined on the replication database. |
|
TransPullSubscriptions | Represents the pull subscriptions to a transactional or snapshot publication defined on the replication database. |
|
UserData | Gets or sets an object property that allows users to attach their own data to the object. (繼承自 ReplicationObject。) |
頂端