Элементы ReplicationDatabase
Represents a publication or subscription database in a replication topology.
Тип ReplicationDatabase предоставляет доступ к следующим элементам.
Конструкторы
Имя | Описание | |
---|---|---|
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. |
В начало
Методы
Имя | Описание | |
---|---|---|
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. |
В начало
Свойства
Имя | Описание | |
---|---|---|
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.) |
В начало