Compartilhar via

  • Artigo

Membros ReplicationDatabase

Represents a publication or subscription database in a replication topology.

O tipo ReplicationDatabase expõe os seguintes membros.

Construtores

  Nome Descrição
Método público ReplicationDatabase() () () () Initializes a new instance of the ReplicationDatabase class.
Método público 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.

Início

Métodos

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

Início

Propriedades

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

Início