• Articolo

Membri ReplicationDatabase

Represents a publication or subscription database in a replication topology.

Il tipo ReplicationDatabase espone i membri seguenti.

Costruttori

  Nome Descrizione
Metodo pubblico ReplicationDatabase() () () () Initializes a new instance of the ReplicationDatabase class.
Metodo pubblico 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 alto

Metodi

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

In alto

Proprietà

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

In alto