ReplicationDatabase Members
Represents a publication or subscription database in a replication topology.
The following tables list the members exposed by the ReplicationDatabase type.
Public Constructors
Nombre | Description | |
---|---|---|
ReplicationDatabase | Overloaded. Initializes a new instance of the ReplicationDatabase class. |
Arriba
Public Properties
Nombre | Description | |
---|---|---|
AllowMergePublication | Specifies whether or not the database can be published using merge replication. | |
CachePropertyChanges | Gets or sets whether to cache changes made to the replication properties or to apply them immediately. (inherited from ReplicationObject) | |
CompatibilityLevel | Gets the minimum version of SQL Server with which the database has compatible behavior. | |
ConnectionContext | Gets or sets the connection to an instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
DBOwner | Gets if the login used by the current connection has ownership rights to the database. | |
DBReadOnly | Gets whether the database is read-only or not. | |
EnabledMergePublishing | Gets or sets whether the database is enabled for merge publishing or not. | |
EnabledTransPublishing | Gets or sets whether the database is enabled for transactional or snapshot publishing or not. | |
HasPublications | Gets whether or not the database has existing publications. | |
HasPullSubscriptions | Gets whether or not the database has existing pull subscriptions. | |
IsExistingObject | Gets whether the object exists on the server or not. (inherited from ReplicationObject) | |
LogReaderAgentExists | Gets whether or not the Log Reader Agent has been created for the publication database. | |
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. | |
LogReaderAgentProcessSecurity | Gets the Microsoft Windows account under which the Log Reader Agent job runs at the Distributor. | |
LogReaderAgentPublisherSecurity | Gets the login used by the Log Reader Agent to connect to the Publisher. | |
MergePublications | Returns the merge publications defined on the replication database. | |
MergePullSubscriptions | Returns the merge pull subscriptions defined on the replication database. | |
Name | Gets or sets the name of the replication database. | |
QueueReaderAgentExists | Gets whether or not a Queue Reader Agent job exists for the database. | |
QueueReaderAgentProcessSecurity | Gets the Microsoft Windows account under which the Queue Reader Agent job runs at the Distributor. | |
SqlServerName | Gets the name of the Microsoft SQL Server instance to which this object is connected. (inherited from ReplicationObject) | |
TransPublications | Returns the transactional or snapshot publications defined on the replication database. | |
TransPullSubscriptions | Represents the pull subscriptions to a transactional or snapshot publication defined on the replication database. | |
UserData | Gets or sets an object property that allows users to attach their own data to the object. (inherited from ReplicationObject) |
Arriba
Public Methods
(see also Protected Methods )
Nombre | Description | |
---|---|---|
CommitPropertyChanges | Sends all the cached property change statements to the instance of Microsoft SQL Server. (inherited from ReplicationObject) | |
CreateLogReaderAgent | Creates a Log Reader Agent job for a database published with transactional replication. | |
CreateQueueReaderAgent | Creates a Queue Reader Agent job for the distribution database. | |
Decouple | Decouples the referenced replication object from the server. (inherited from ReplicationObject) | |
EnumConflictTables | Returns conflict information for all merge publications and subscriptions that use the replication database. | |
EnumMergeConflictCounts | Returns information on conflicts stored in a merge publication or subscription database. | |
EnumMergePublications | Returns a list of merge publications that use the replication database. | |
EnumMergePullSubscriptions | Returns all merge pull subscriptions that use this replication database. | |
EnumPublicationArticles | Returns replication information for published objects in the replication database. | |
EnumReplicationSchemaBoundViews | Returns all user-defined schema-bound view objects in the database. | |
EnumReplicationStoredProcedures | Returns all user-defined stored procedure objects in the database. | |
EnumReplicationTables | Returns all user-defined table objects in the database. | |
EnumReplicationUserDefinedAggregates | Returns a list of user-defined aggregates in the database. | |
EnumReplicationUserDefinedFunctions | Returns a list of user-defined functions in the database. | |
EnumReplicationViews | Returns a list of the user-defined views objects in the database. | |
EnumTransConflictCounts | Returns information on conflicts stored in an updating transactional publication or subscription database. | |
EnumTransPublications | Returns a list of transactional and snapshot publications that use the database. | |
EnumTransPullSubscriptions | Returns a list of transactional and snapshot pull subscriptions that use the database. | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
LinkPublicationForUpdateableSubscription | Sets the configuration and security information used by synchronization triggers of updatable subscriptions when connecting to the Publisher. | |
Load | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
LoadProperties | Loads the properties of an existing object from the server. (inherited from ReplicationObject) | |
ReadSubscriptionFailoverMode | Returns the failover mode for an updating subscription to a transactional or snapshot publication. | |
ReferenceEquals | (inherited from Object ) | |
Refresh | Reloads the properties of the object. (inherited from ReplicationObject) | |
Script | Returns a Transact-SQL script to enable or disable replication publishing and subscriptions on the database based on the properties of ReplicationDatabase. | |
ScriptReplicationDBOption | Returns a Transact-SQL script to enable or disable replication options on the database based on the properties of ReplicationDatabase. | |
ToString | (inherited from Object ) | |
WriteSubscriptionFailoverMode | Sets the failover mode for an updating subscription to a transactional or snapshot publication. |
Arriba
Protected Methods
Nombre | Description | |
---|---|---|
CheckValidCreation | (inherited from ReplicationObject ) | |
CheckValidDefinition | (inherited from ReplicationObject ) | |
Finalize | (inherited from Object ) | |
GetChangeCommand | (inherited from ReplicationObject ) | |
GetCreateCommand | (inherited from ReplicationObject ) | |
GetDropCommand | (inherited from ReplicationObject ) | |
InternalRefresh | (inherited from ReplicationObject ) | |
MemberwiseClone | (inherited from Object ) |
Arriba
Vea también
Referencia
ReplicationDatabase Class
Microsoft.SqlServer.Replication Namespace
Otros recursos
How to: Configure Publishing and Distribution (RMO Programming)
How to: Create a Publication (RMO Programming)
How to: Delete a Publication (RMO Programming)