Microsoft.SqlServer.Replication 네임스페이스
The Microsoft.SqlServer.Replication namespace implements the Replication Management Object (RMO) model. RMO provides programmatic access to Microsoft SQL Server replication from a managed code environment.
클래스
클래스 | 설명 | |
---|---|---|
AgentJobHistoryInfo | Returns information about the results of the last run of a replication agent. | |
AgentProfile | Encapsulates all operations on replication agent profiles, such as creating, deleting, adding, and removing parameters, and assigning specific profiles to certain agents. | |
AgentProfileParameter | Represents parameters in a replication agent profile. | |
AgentProfileParameterInfo | Represents a supported parameter used in replication agent profiles. | |
Article | The base class from which the TransArticle class and MergeArticle class are derived. | |
ArticleConflict | Represents information about a merge replication conflict table. | |
BusinessLogicHandler | Represents the server registration for the managed code assembly that implements a business logic handler. | |
ConnectionSecurityContext | Represents information you use when you connect to Microsoft SQL Server. | |
CustomResolver | Represents a COM-based resolver registration at a server in a merge replication topology. | |
DistributionArticle | Represents information about an article published in a transactional or snapshot publication stored at the Distributor. | |
DistributionArticleCollection | Represents a collection of DistributionArticle objects. | |
DistributionDatabase | Represents a distribution database at the Distributor. | |
DistributionDatabaseCollection | Represents a collection of DistributionDatabase objects. | |
DistributionPublication | Represents information about a transactional or snapshot publication stored at the Distributor. | |
DistributionPublicationCollection | Represents a collection of DistributionPublication objects. | |
DistributionPublisher | Represents information about a Publisher registered at the currently connected Distributor. | |
DistributionPublisherCollection | Represents a collection of DistributionPublisher objects. | |
DistributionSubscription | Represents information stored at the Distributor about a subscription to a transactional or snapshot publication. | |
DistributionSubscriptionCollection | Represents a collection of DistributionSubscription objects. | |
HeterogeneousColumn | Represents a column contained in a table on a non-Microsoft SQL Server Publisher. | |
HeterogeneousTable | Represents a table on a non-Microsoft SQL Server Publisher. | |
IdentityRangeInfo | Structure that represents identity range management settings for a published article when the source table contains identity columns. | |
LastValidationDateTime | Used to return the date and time of the last merge subscription validation. | |
LightPublication | 인프라 | |
MergeArticle | Represents an article in a merge publication. | |
MergeArticleCollection | Represents a collection of MergeArticle objects. | |
MergeConflictCount | Represents conflict information for a table article in a merge publication. | |
MergeDynamicSnapshotJob | Contains information about the Snapshot Agent job that generates the data snapshot for a subscription to a merge publication with a parameterized row filter. | |
MergeJoinFilter | Represents a join filter or logical record relationship between to merge articles. | |
MergePartition | Represents information about a Subscriber's partition for a merge publication with a parameterized row filter. | |
MergePublication | Represents a merge publication. | |
MergePublicationCollection | Represents a collection of MergePublication objects. | |
MergePullSubscription | Represents a pull subscription to a merge publication. | |
MergePullSubscriptionCollection | Represents a collection of MergePullSubscription objects. | |
MergeSessionDetail | Represents detailed information about a step in a Merge Agent session. | |
MergeSessionError | Represents information on errors that occur during a Merge Agent session. | |
MergeSessionSummary | Represents Merge Agent session information. | |
MergeSubscriberMonitor | Enables Subscriber-side monitoring of subscriptions to merge publications. | |
MergeSubscription | Represents a subscription to a merge publication registered at the Publisher. | |
MergeSubscriptionCollection | Represents a collection of MergeSubscription objects. | |
MonitorThreshold | Represents a threshold metric used when monitoring a publication. | |
PendingCommandInfo | Represents information on the number of pending commands for a subscription to a transactional publication and a rough estimate of how much time it takes to process them. | |
Publication | The Publication class is a base class from which the TransPublication class and the MergePublication class are derived. | |
PublicationAccess | Represents login information in the publication access list (PAL) for a publication. | |
PublicationArticle | Represents article information for a published database object. | |
PublicationMonitor | Monitors a publication. | |
PublicationMonitorCollection | A collection of PublicationMonitor objects that represents publications at the Distributor. | |
PublisherConnectionSecurityContext | Represents the login used when connecting to the instance of Microsoft SQL Server that is configured as a Publisher in a replication topology. | |
PublisherMonitor | Monitors a replication Publisher. | |
PublisherMonitorCollection | Represents a collection of PublisherMonitor objects. | |
PullSubscription | Represents information at the Publisher for a subscription to a merge or a transactional publication when the Synchronization Agent runs at the Subscriber. PullSubscription is a base class from which the TransPullSubscription class and the MergePullSubscription class are derived. | |
RegisteredSubscriber | Represents a Subscriber that has been registered at a Publisher or a Distributor. | |
RegisteredSubscriberCollection | Represents a collection of RegisteredSubscriber objects. | |
ReplicationAgentSchedule | Represents the schedule for a replication agent job. | |
ReplicationBaseCollection | The base class that is used in the construction of replication object collections. It contains functionality that is common to the replication object collections. | |
ReplicationColumn | Represents a column object in a table that contains information needed by replication. | |
ReplicationDatabase | Represents a publication or subscription database in a replication topology. | |
ReplicationDatabaseCollection | Represents a collection of ReplicationDatabase objects. | |
ReplicationMonitor | Monitors a replication server. | |
ReplicationObject | Abstract class that is the base class for all classes in the Replication Management Objects (RMO) programming interface. | |
ReplicationSchemaBoundView | Represents a schema-bound view and contains information needed by replication. | |
ReplicationServer | Represents an instance of Microsoft SQL Server that is involved in replication. It can take the role of Distributor, Publisher, Subscriber, or any combination of them. | |
ReplicationStatusAndWarning | Represents replication agent status information and threshold monitor warnings. | |
ReplicationStoredProcedure | Represents information on a stored procedure object that is required by replication. | |
ReplicationTable | Represents information on a table object that is required by replication. | |
ReplicationUserDefinedAggregate | Represents a user-defined aggregate function and contains information needed by replication. | |
ReplicationUserDefinedFunction | Represents a user-defined function and contains information needed by replication. | |
ReplicationView | Represents information on a view object that is required by replication. | |
SubscriberSubscription | Returns information about a subscription. | |
Subscription | Represents information at the Publisher for a subscription to either a merge or a transactional publication. Subscription is a base class from which the TransSubscription class and the MergeSubscription class are derived. | |
SubscriptionBackupInformation | Represents information required to initialize a subscription from a backup. | |
SynchronizationPartner | Represents an alternate Publisher used to synchronize a subscription to a merge publication. | |
TracerToken | Represents tracer token information. | |
TransArticle | Represents an article in a transactional publication. | |
TransArticleCollection | Represents a collection of TransArticle objects. | |
TransConflictCount | Represents returned conflict information for a table article in a publication that supports queued updating subscriptions. | |
TransPublication | Represents a transactional publication. | |
TransPublicationCollection | Represents a collection of TransPublication objects. | |
TransPullSubscription | Represents a pull subscription to a transactional publication. | |
TransPullSubscriptionCollection | Represents a collection of TransPullSubscription objects. | |
TransSubscription | Represents a push subscription to a transactional or snapshot publication. | |
TransSubscriptionCollection | Represents a collection of TransSubscription objects. |
인터페이스
인터페이스 | 설명 | |
---|---|---|
IConnectionSecurityContext | Provides an implementation of the ConnectionSecurityContext class for late-bound COM clients. For information on the members of this interface, see the reference documentation for ConnectionSecurityContext. | |
IProcessSecurityContext | Interface that encapsulates the Microsoft Windows security account information used by Microsoft SQL Server Agent to start a replication agent job. | |
IReplicationDBObject | 인프라 |
열거형
열거형 | 설명 | |
---|---|---|
AddColumnOption | Enumerates the options for adding a column to a table published in an existing publication. | |
AgentProfileTypeOption | Indicates whether a replication agent profile is system-defined or user-defined. | |
AgentType | Enumerates the various types of replication agents. | |
ArticleDatatypeMappingOptions | Specifies whether the data type mapping between two database management systems (DBMS) for an article has been defined by a user or is the default mapping. | |
ArticleOptions | Enumerates the type of database objects that can be published by replication. | |
AuthenticationMethod | Enumerates values that specify the supported HTTP authentication methods for Web synchronization. | |
AutomaticReinitializationPolicies | Enumerates default behaviors when reinitializing subscriptions to a merge publication. | |
CheckPermissionOptions | Enumerates the table-level permissions that are verified when the Merge Agent applies changes at the Publisher. | |
CommandOptions | Enumerates options that control how changes are propagated for transactional articles. | |
ConflictPolicyOption | Enumerates options for selecting the winning row when conflicts occur during synchronization of an updating subscription to a transactional publication. | |
CreationScriptOptions | Enumerates schema option values for published articles. | |
DatabaseCompatibilityLevel | Enumerates the versions of Microsoft SQL Server that are supported for database compatibility with Microsoft SQL Server 2005. | |
DdlReplicationOptions | Enumerates whether data definition language (DDL) changes to published tables are replicated. | |
DtsPackageLocationOption | Enumerates options for the location of the Data Transformation Services (DTS) package. | |
FailoverMode | Enumerates the options available for an updating Subscriber to propagate changes back to the Publisher. | |
FilterTypes | Enumerates values that specify the type of filters used in merge articles. | |
IdentityRangeManagementOption | Enumerates options for managing identity column range assignments in tables published using merge replication and transactional replication with updating Subscribers. | |
InitialSyncType | Enumerates the data file formats supported for the initial snapshot. | |
MergeArticleState | Enumerates the supported status settings for a merge article. | |
MergeSessionDetailType | Enumerates parts of a Merge Agent session being monitored. | |
MergeSessionPhase | Enumerates the phase of a Merge Agent session. | |
MergeSessionStatus | Enumerates the status of a Merge Agent session. | |
MergeSubscriberType | Enumeration additional types of subscriptions supported by merge replication. | |
MonitorCacheRefreshPolicy | 인프라 | |
PartitionGroupsOption | Enumerates values that determine whether a merge publication uses precomputed partitions. | |
PartitionOptions | Enumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter. | |
PreCreationOption | Enumerates the commands that are executed prior to subscription initialization when a published table already exists in the subscription database. | |
PublicationAttributes | Enumerates supported publication properties. | |
PublicationCompatibilityLevel | Enumerates product version values that are used by merge replication to determine which features can be used by publications in a given database. | |
PublicationType | Enumerates the supported types of replication used to publish a database. | |
QueueOption | Enumerates the type of queuing available to a transactional publication with updating Subscribers. | |
ReplicationSecurityMode | Specifies the supported security modes used by updating Subscribers when connecting to the Publisher. | |
ReplicationStatus | Specifies the status of a replication agent job. | |
ReplicationWarnings | Enumerates the supported replication threshold monitor warning values. | |
ResynchronizeType | Enumerates values that specify the changes to apply when a merge subscription is resynchronized. | |
RetentionPeriodUnits | Enumerates values that specify the units for the retention period. | |
ScheduleConstant | Enumerates constant values used to set replication schedules. | |
ScheduleFrequencySubDay | Enumerates values that specify a smaller scheduling unit for specific schedule frequencies. | |
ScheduleFrequencyType | Enumerates the types of frequencies used when scheduling a replication agent job. | |
ScheduleRelativeIntervals | Enumerates values that represent the frequency of a replication agent schedule relative to the ScheduleFrequencyType. | |
ScriptOptions | Enumerates options for generating scripts that are used to create or remove replication objects. | |
State | Enumerates the values that represent the status of a publication. | |
SubscriberType | Enumerates the types of data sources that can be a Subscriber to a publication. | |
SubscriberUploadOptions | Enumerates merge article options for updates made at a Subscriber with a client subscription. | |
SubscriptionBackupDeviceType | Enumerates backup devices that can be used to initialize a subscription. | |
SubscriptionResultOption | Enumerates options for returning monitored subscriptions. | |
SubscriptionState | Enumerates options for the status of a subscription. | |
SubscriptionSyncType | Enumerates options for how the initial synchronization is performed for a subscription. | |
TransSubscriberType | Enumerates the updating behaviors for subscriptions to transactional publications. | |
ValidationMethod | Enumerates methods supported for rowcount validation of transactional publications. | |
ValidationOption | Enumerates the types of data validation supported by replication. | |
VerifyResolverSignatureOption | Enumerates values that specify whether the Merge Agent must verify the digital signature on a Component Object Model (COM)-based conflict resolver to determine if it is from a trusted source. |