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

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

Top

Public Properties

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

Top

Public Methods

(see also Protected Methods )

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

Top

Protected Methods

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

Top

See Also

Reference

ReplicationDatabase Class
Microsoft.SqlServer.Replication Namespace

Other Resources

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