Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

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.

AgentJobHistoryInfoReturns information about the results of the last run of a replication agent.
AgentProfileEncapsulates all operations on replication agent profiles, such as creating, deleting, adding, and removing parameters, and assigning specific profiles to certain agents.
AgentProfileParameterRepresents parameters in a replication agent profile.
AgentProfileParameterInfoRepresents a supported parameter used in replication agent profiles.
ArticleThe base class from which the TransArticle class and MergeArticle class are derived.
ArticleConflictRepresents information about a merge replication conflict table.
BusinessLogicHandlerRepresents the server registration for the managed code assembly that implements a business logic handler.
ConnectionSecurityContextRepresents information you use when you connect to Microsoft SQL Server.
CustomResolverRepresents a COM-based resolver registration at a server in a merge replication topology.
DistributionArticleRepresents information about an article published in a transactional or snapshot publication stored at the Distributor.
DistributionArticleCollectionRepresents a collection of DistributionArticle objects.
DistributionDatabaseRepresents a distribution database at the Distributor.
DistributionDatabaseCollectionRepresents a collection of DistributionDatabase objects.
DistributionPublicationRepresents information about a transactional or snapshot publication stored at the Distributor.
DistributionPublicationCollectionRepresents a collection of DistributionPublication objects.
DistributionPublisherRepresents information about a Publisher registered at the currently connected Distributor.
DistributionPublisherCollectionRepresents a collection of DistributionPublisher objects.
DistributionSubscriptionRepresents information stored at the Distributor about a subscription to a transactional or snapshot publication.
DistributionSubscriptionCollectionRepresents a collection of DistributionSubscription objects.
HeterogeneousColumnRepresents a column contained in a table on a non-Microsoft SQL Server Publisher.
HeterogeneousTableRepresents a table on a non-Microsoft SQL Server Publisher.
IdentityRangeInfoStructure that represents identity range management settings for a published article when the source table contains identity columns.
LastValidationDateTimeUsed to return the date and time of the last merge subscription validation.
MergeArticleRepresents an article in a merge publication.
MergeArticleCollectionRepresents a collection of MergeArticle objects.
MergeConflictCountRepresents conflict information for a table article in a merge publication.
MergeDynamicSnapshotJobContains information about the Snapshot Agent job that generates the data snapshot for a subscription to a merge publication with a parameterized row filter.
MergeJoinFilterRepresents a join filter or logical record relationship between to merge articles.
MergePartitionRepresents information about a Subscriber's partition for a merge publication with a parameterized row filter.
MergePublicationRepresents a merge publication.
MergePublicationCollectionRepresents a collection of MergePublication objects.
MergePullSubscriptionRepresents a pull subscription to a merge publication.
MergePullSubscriptionCollectionRepresents a collection of MergePullSubscription objects.
MergeSessionDetailRepresents detailed information about a step in a Merge Agent session.
MergeSessionErrorRepresents information on errors that occur during a Merge Agent session.
MergeSessionSummaryRepresents Merge Agent session information.
MergeSubscriberMonitorEnables Subscriber-side monitoring of subscriptions to merge publications.
MergeSubscriptionRepresents a subscription to a merge publication registered at the Publisher.
MergeSubscriptionCollectionRepresents a collection of MergeSubscription objects.
MonitorThresholdRepresents a threshold metric used when monitoring a publication.
PendingCommandInfoRepresents 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.
PublicationThe Publication class is a base class from which the TransPublication class and the MergePublication class are derived.
PublicationAccessRepresents login information in the publication access list (PAL) for a publication.
PublicationArticleRepresents article information for a published database object.
PublicationMonitorMonitors a publication.
PublicationMonitorCollectionA collection of PublicationMonitor objects that represents publications at the Distributor.
PublisherConnectionSecurityContextRepresents the login used when connecting to the instance of Microsoft SQL Server that is configured as a Publisher in a replication topology.
PublisherMonitorMonitors a replication Publisher.
PublisherMonitorCollectionRepresents a collection of PublisherMonitor objects.
PullSubscriptionRepresents 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.
RegisteredSubscriberRepresents a Subscriber that has been registered at a Publisher or a Distributor.
RegisteredSubscriberCollectionRepresents a collection of RegisteredSubscriber objects.
ReplicationAgentScheduleRepresents the schedule for a replication agent job.
ReplicationBaseCollectionThe base class that is used in the construction of replication object collections. It contains functionality that is common to the replication object collections.
ReplicationColumnRepresents a column object in a table that contains information needed by replication.
ReplicationDatabaseRepresents a publication or subscription database in a replication topology.
ReplicationDatabaseCollectionRepresents a collection of ReplicationDatabase objects.
ReplicationMonitorMonitors a replication server.
ReplicationObjectAbstract class that is the base class for all classes in the Replication Management Objects (RMO) programming interface.
ReplicationSchemaBoundViewRepresents a schema-bound view and contains information needed by replication.
ReplicationServerRepresents 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.
ReplicationStatusAndWarningRepresents replication agent status information and threshold monitor warnings.
ReplicationStoredProcedureRepresents information on a stored procedure object that is required by replication.
ReplicationTableRepresents information on a table object that is required by replication.
ReplicationUserDefinedAggregateRepresents a user-defined aggregate function and contains information needed by replication.
ReplicationUserDefinedFunctionRepresents a user-defined function and contains information needed by replication.
ReplicationViewRepresents information on a view object that is required by replication.
SubscriberSubscriptionReturns information about a subscription.
SubscriptionRepresents 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.
SubscriptionBackupInformationRepresents information required to initialize a subscription from a backup.
SynchronizationPartnerRepresents an alternate Publisher used to synchronize a subscription to a merge publication.
TracerTokenRepresents tracer token information.
TransArticleRepresents an article in a transactional publication.
TransArticleCollectionRepresents a collection of TransArticle objects.
TransConflictCountRepresents returned conflict information for a table article in a publication that supports queued updating subscriptions.
TransPublicationRepresents a transactional publication.
TransPublicationCollectionRepresents a collection of TransPublication objects.
TransPullSubscriptionRepresents a pull subscription to a transactional publication.
TransPullSubscriptionCollectionRepresents a collection of TransPullSubscription objects.
TransSubscriptionRepresents a push subscription to a transactional or snapshot publication.
TransSubscriptionCollectionRepresents a collection of TransSubscription objects.

IConnectionSecurityContextProvides 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.
IProcessSecurityContextInterface that encapsulates the Microsoft Windows security account information used by Microsoft SQL Server Agent to start a replication agent job.

AddColumnOptionEnumerates the options for adding a column to a table published in an existing publication.
AgentProfileTypeOptionIndicates whether a replication agent profile is system-defined or user-defined.
AgentTypeEnumerates the various types of replication agents.
ArticleDatatypeMappingOptionsSpecifies 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.
ArticleOptionsEnumerates the type of database objects that can be published by replication.
AuthenticationMethodEnumerates values that specify the supported HTTP authentication methods for Web synchronization.
AutomaticReinitializationPoliciesEnumerates default behaviors when reinitializing subscriptions to a merge publication.
CheckPermissionOptionsEnumerates the table-level permissions that are verified when the Merge Agent applies changes at the Publisher.
CommandOptionsEnumerates options that control how changes are propagated for transactional articles.
ConflictPolicyOptionEnumerates options for selecting the winning row when conflicts occur during synchronization of an updating subscription to a transactional publication.
CreationScriptOptionsEnumerates schema option values for published articles.
DatabaseCompatibilityLevelEnumerates the versions of Microsoft SQL Server that are supported for database compatibility with Microsoft SQL Server 2005.
DdlReplicationOptionsEnumerates whether data definition language (DDL) changes to published tables are replicated.
DtsPackageLocationOptionEnumerates options for the location of the Data Transformation Services (DTS) package.
FailoverModeEnumerates the options available for an updating Subscriber to propagate changes back to the Publisher.
FilterTypesEnumerates values that specify the type of filters used in merge articles.
IdentityRangeManagementOptionEnumerates options for managing identity column range assignments in tables published using merge replication and transactional replication with updating Subscribers.
InitialSyncTypeEnumerates the data file formats supported for the initial snapshot.
MergeArticleStateEnumerates the supported status settings for a merge article.
MergeSessionDetailTypeEnumerates parts of a Merge Agent session being monitored.
MergeSessionPhaseEnumerates the phase of a Merge Agent session.
MergeSessionStatusEnumerates the status of a Merge Agent session.
MergeSubscriberTypeEnumeration additional types of subscriptions supported by merge replication.
PartitionGroupsOptionEnumerates values that determine whether a merge publication uses precomputed partitions.
PartitionOptionsEnumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter.
PreCreationOptionEnumerates the commands that are executed prior to subscription initialization when a published table already exists in the subscription database.
PublicationAttributesEnumerates supported publication properties.
PublicationCompatibilityLevelEnumerates product version values that are used by merge replication to determine which features can be used by publications in a given database.
PublicationTypeEnumerates the supported types of replication used to publish a database.
QueueOptionEnumerates the type of queuing available to a transactional publication with updating Subscribers.
ReplicationSecurityModeSpecifies the supported security modes used by updating Subscribers when connecting to the Publisher.
ReplicationStatusSpecifies the status of a replication agent job.
ReplicationWarningsEnumerates the supported replication threshold monitor warning values.
ResynchronizeTypeEnumerates values that specify the changes to apply when a merge subscription is resynchronized.
RetentionPeriodUnitsEnumerates values that specify the units for the retention period.
ScheduleConstantEnumerates constant values used to set replication schedules.
ScheduleFrequencySubDayEnumerates values that specify a smaller scheduling unit for specific schedule frequencies.
ScheduleFrequencyTypeEnumerates the types of frequencies used when scheduling a replication agent job.
ScheduleRelativeIntervalsEnumerates values that represent the frequency of a replication agent schedule relative to the ScheduleFrequencyType.
ScriptOptionsEnumerates options for generating scripts that are used to create or remove replication objects.
StateEnumerates the values that represent the status of a publication.
SubscriberTypeEnumerates the types of data sources that can be a Subscriber to a publication.
SubscriberUploadOptionsEnumerates merge article options for updates made at a Subscriber with a client subscription.
SubscriptionBackupDeviceTypeEnumerates backup devices that can be used to initialize a subscription.
SubscriptionResultOptionEnumerates options for returning monitored subscriptions.
SubscriptionStateEnumerates options for the status of a subscription.
SubscriptionSyncTypeEnumerates options for how the initial synchronization is performed for a subscription.
TransSubscriberTypeEnumerates the updating behaviors for subscriptions to transactional publications.
ValidationMethodEnumerates methods supported for rowcount validation of transactional publications.
ValidationOptionEnumerates the types of data validation supported by replication.
VerifyResolverSignatureOptionEnumerates 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.
© 2016 Microsoft