ReplicationDatabase Members

  • Article

Represents a publication or subscription database in a replication topology.

The following tables list the members exposed by the ReplicationDatabase type.

Public Constructors

  Nom Description
ReplicationDatabase Overloaded. Initializes a new instance of the ReplicationDatabase class.

Haut de la page

Public Properties

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

Haut de la page

Public Methods

(see also Protected Methods )

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

Haut de la page

Protected Methods

  Nom Description
ms158335.protmethod(fr-fr,SQL.90).gif CheckValidCreation  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif CheckValidDefinition  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif Finalize  (inherited from Object )
ms158335.protmethod(fr-fr,SQL.90).gif GetChangeCommand  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif GetCreateCommand  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif GetDropCommand  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif InternalRefresh  (inherited from ReplicationObject )
ms158335.protmethod(fr-fr,SQL.90).gif MemberwiseClone  (inherited from Object )

Haut de la page

Voir aussi

Référence

ReplicationDatabase Class
Microsoft.SqlServer.Replication Namespace

Autres ressources

How to: Configure Publishing and Distribution (RMO Programming)
How to: Create a Publication (RMO Programming)
How to: Delete a Publication (RMO Programming)