مشاركة عبر

  • مقالة

ReplicationDatabase Members

Include Protected Members
Include Inherited Members

Represents a publication or subscription database in a replication topology.

The ReplicationDatabase type exposes the following members.

Constructors

  Name Description
Public method ReplicationDatabase() Initializes a new instance of the ReplicationDatabase class.
Public method 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.

Top

Methods

  Name Description
Protected method CheckValidCreation() Infrastructure. (Inherited from ReplicationObject.)
Protected method CheckValidDefinition(Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method CommitPropertyChanges() Sends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public method CreateLogReaderAgent() Creates a Log Reader Agent job for a database published with transactional replication.
Public method CreateQueueReaderAgent() Creates a Queue Reader Agent job for the distribution database.
Public method Decouple() Decouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public method EnumConflictTables(String) Returns conflict information for all merge publications and subscriptions that use the replication database.
Public method EnumMergeConflictCounts(String, String, String) Returns information on conflicts stored in a merge publication or subscription database.
Public method EnumMergePublications() Returns a list of merge publications that use the replication database.
Public method EnumMergePullSubscriptions() Returns all merge pull subscriptions that use this replication database.
Public method EnumPublicationArticles(String) Returns replication information for published objects in the replication database.
Public method EnumReplicationSchemaBoundViews() Returns all user-defined schema-bound view objects in the database.
Public method EnumReplicationStoredProcedures() Returns all user-defined stored procedure objects in the database.
Public method EnumReplicationTables() Returns all user-defined table objects in the database.
Public method EnumReplicationUserDefinedAggregates() Returns a list of user-defined aggregates in the database.
Public method EnumReplicationUserDefinedFunctions() Returns a list of user-defined functions in the database.
Public method EnumReplicationViews() Returns a list of the user-defined views objects in the database.
Public method EnumTransConflictCounts(String, String, String) Returns information on conflicts stored in an updating transactional publication or subscription database.
Public method EnumTransPublications() Returns a list of transactional and snapshot publications that use the database.
Public method EnumTransPullSubscriptions() Returns a list of transactional and snapshot pull subscriptions that use the database.
Public method Equals(Object) (Inherited from Object.)
Protected method Finalize() (Inherited from Object.)
Protected method GetChangeCommand(StringBuilder, String, String) Infrastructure. (Inherited from ReplicationObject.)
Protected method GetCreateCommand(StringBuilder, Boolean, ScriptOptions) Infrastructure. (Inherited from ReplicationObject.)
Protected method GetDropCommand(StringBuilder, Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method GetHashCode() (Inherited from Object.)
Public method GetType() (Inherited from Object.)
Protected method InternalRefresh(Boolean) Infrastructure. (Inherited from ReplicationObject.)
Public method LinkPublicationForUpdateableSubscription(String, String, String, String, PublisherConnectionSecurityContext) Sets the configuration and security information used by synchronization triggers of updatable subscriptions when connecting to the Publisher.
Public method Load() Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public method LoadProperties() Loads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Protected method MemberwiseClone() (Inherited from Object.)
Public method ReadSubscriptionFailoverMode(String, String, String) Returns the failover mode for an updating subscription to a transactional or snapshot publication.
Public method Refresh() Reloads the properties of the object. (Inherited from ReplicationObject.)
Public method Script(ScriptOptions) Returns a Transact-SQL script to enable or disable replication publishing and subscriptions on the database based on the properties of ReplicationDatabase.
Public method ScriptReplicationDBOption(ScriptOptions) Returns a Transact-SQL script to enable or disable replication options on the database based on the properties of ReplicationDatabase.
Public method ToString() (Inherited from Object.)
Public method WriteSubscriptionFailoverMode(String, String, String, FailoverMode) Sets the failover mode for an updating subscription to a transactional or snapshot publication.

Top

Properties

  Name Description
Public property AllowMergePublication Specifies whether or not the database can be published using merge replication.
Public property CachePropertyChanges Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public property CompatibilityLevel Gets the minimum version of SQL Server with which the database has compatible behavior.
Public property ConnectionContext Gets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public property DBOwner Gets if the login used by the current connection has ownership rights to the database.
Public property DBReadOnly Gets whether the database is read-only or not.
Public property EnabledMergePublishing Gets or sets whether the database is enabled for merge publishing or not.
Public property EnabledTransPublishing Gets or sets whether the database is enabled for transactional or snapshot publishing or not.
Public property HasPublications Gets whether or not the database has existing publications.
Public property HasPullSubscriptions Gets whether or not the database has existing pull subscriptions.
Public property IsExistingObject Gets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public property LogReaderAgentExists Gets whether or not the Log Reader Agent has been created for the publication database.
Public property 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.
Public property LogReaderAgentProcessSecurity Gets the Microsoft Windows account under which the Log Reader Agent job runs at the Distributor.
Public property LogReaderAgentPublisherSecurity Gets the login used by the Log Reader Agent to connect to the Publisher.
Public property MergePublications Returns the merge publications defined on the replication database.
Public property MergePullSubscriptions Returns the merge pull subscriptions defined on the replication database.
Public property Name Gets or sets the name of the replication database.
Public property QueueReaderAgentExists Gets whether or not a Queue Reader Agent job exists for the database.
Public property QueueReaderAgentProcessSecurity Gets the Microsoft Windows account under which the Queue Reader Agent job runs at the Distributor.
Public property SqlServerName Gets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public property TransPublications Returns the transactional or snapshot publications defined on the replication database.
Public property TransPullSubscriptions Represents the pull subscriptions to a transactional or snapshot publication defined on the replication database.
Public property UserData Gets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)

Top