Microsoft.SqlServer.Replication Namespace
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.
Classes
Class | Description | |
---|---|---|
![]() |
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 | Infrastructure. |
![]() |
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. |
Interfaces
Interface | Description | |
---|---|---|
![]() |
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 | Infrastructure. |
Enumerations
Enumeration | Description | |
---|---|---|
![]() |
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 | Infrastructure. |
![]() |
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. |