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
| 이름 | Description | |
|---|---|---|
| ReplicationDatabase | Overloaded. Initializes a new instance of the ReplicationDatabase class. |
위쪽
Public Properties
| 이름 | Description | |
|---|---|---|
.gif "ms158335.pubproperty(ko-kr,SQL.90).gif") |
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) |
위쪽
Public Methods
(see also Protected Methods )
| 이름 | Description | |
|---|---|---|
.gif "ms158335.pubmethod(ko-kr,SQL.90).gif") |
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. |
.gif "ms158335.static(ko-kr,SQL.90).gif") |
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. |
위쪽
Protected Methods
| 이름 | Description | |
|---|---|---|
.gif "ms158335.protmethod(ko-kr,SQL.90).gif") |
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 ) |
위쪽
참고 항목
참조
ReplicationDatabase Class
Microsoft.SqlServer.Replication Namespace
관련 자료
How to: Configure Publishing and Distribution (RMO Programming)
How to: Create a Publication (RMO Programming)
How to: Delete a Publication (RMO Programming)