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.

Public classAgentJobHistoryInfoReturns information about the results of the last run of a replication agent.
Public classAgentProfileEncapsulates all operations on replication agent profiles, such as creating, deleting, adding, and removing parameters, and assigning specific profiles to certain agents.
Public classAgentProfileParameterRepresents parameters in a replication agent profile.
Public classAgentProfileParameterInfoRepresents a supported parameter used in replication agent profiles.
Public classArticleThe base class from which the TransArticle class and MergeArticle class are derived.
Public classArticleConflictRepresents information about a merge replication conflict table.
Public classBusinessLogicHandlerRepresents the server registration for the managed code assembly that implements a business logic handler.
Public classConnectionSecurityContextRepresents information you use when you connect to Microsoft SQL Server.
Public classCustomResolverRepresents a COM-based resolver registration at a server in a merge replication topology.
Public classDistributionArticleRepresents information about an article published in a transactional or snapshot publication stored at the Distributor.
Public classDistributionArticleCollectionRepresents a collection of DistributionArticle objects.
Public classDistributionDatabaseRepresents a distribution database at the Distributor.
Public classDistributionDatabaseCollectionRepresents a collection of DistributionDatabase objects.
Public classDistributionPublicationRepresents information about a transactional or snapshot publication stored at the Distributor.
Public classDistributionPublicationCollectionRepresents a collection of DistributionPublication objects.
Public classDistributionPublisherRepresents information about a Publisher registered at the currently connected Distributor.
Public classDistributionPublisherCollectionRepresents a collection of DistributionPublisher objects.
Public classDistributionSubscriptionRepresents information stored at the Distributor about a subscription to a transactional or snapshot publication.
Public classDistributionSubscriptionCollectionRepresents a collection of DistributionSubscription objects.
Public classHeterogeneousColumnRepresents a column contained in a table on a non-Microsoft SQL Server Publisher.
Public classHeterogeneousTableRepresents a table on a non-Microsoft SQL Server Publisher.
Public classIdentityRangeInfoStructure that represents identity range management settings for a published article when the source table contains identity columns.
Public classLastValidationDateTimeUsed to return the date and time of the last merge subscription validation.
Public classLightPublicationInfrastructure.
Public classMergeArticleRepresents an article in a merge publication.
Public classMergeArticleCollectionRepresents a collection of MergeArticle objects.
Public classMergeConflictCountRepresents conflict information for a table article in a merge publication.
Public classMergeDynamicSnapshotJobContains information about the Snapshot Agent job that generates the data snapshot for a subscription to a merge publication with a parameterized row filter.
Public classMergeJoinFilterRepresents a join filter or logical record relationship between to merge articles.
Public classMergePartitionRepresents information about a Subscriber's partition for a merge publication with a parameterized row filter.
Public classMergePublicationRepresents a merge publication.
Public classMergePublicationCollectionRepresents a collection of MergePublication objects.
Public classMergePullSubscriptionRepresents a pull subscription to a merge publication.
Public classMergePullSubscriptionCollectionRepresents a collection of MergePullSubscription objects.
Public classMergeSessionDetailRepresents detailed information about a step in a Merge Agent session.
Public classMergeSessionErrorRepresents information on errors that occur during a Merge Agent session.
Public classMergeSessionSummaryRepresents Merge Agent session information.
Public classMergeSubscriberMonitorEnables Subscriber-side monitoring of subscriptions to merge publications.
Public classMergeSubscriptionRepresents a subscription to a merge publication registered at the Publisher.
Public classMergeSubscriptionCollectionRepresents a collection of MergeSubscription objects.
Public classMonitorThresholdRepresents a threshold metric used when monitoring a publication.
Public classPendingCommandInfoRepresents 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.
Public classPublicationThe Publication class is a base class from which the TransPublication class and the MergePublication class are derived.
Public classPublicationAccessRepresents login information in the publication access list (PAL) for a publication.
Public classPublicationArticleRepresents article information for a published database object.
Public classPublicationMonitorMonitors a publication.
Public classPublicationMonitorCollectionA collection of PublicationMonitor objects that represents publications at the Distributor.
Public classPublisherConnectionSecurityContextRepresents the login used when connecting to the instance of Microsoft SQL Server that is configured as a Publisher in a replication topology.
Public classPublisherMonitorMonitors a replication Publisher.
Public classPublisherMonitorCollectionRepresents a collection of PublisherMonitor objects.
Public classPullSubscriptionRepresents 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.
Public classRegisteredSubscriberRepresents a Subscriber that has been registered at a Publisher or a Distributor.
Public classRegisteredSubscriberCollectionRepresents a collection of RegisteredSubscriber objects.
Public classReplicationAgentScheduleRepresents the schedule for a replication agent job.
Public classReplicationBaseCollectionThe base class that is used in the construction of replication object collections. It contains functionality that is common to the replication object collections.
Public classReplicationColumnRepresents a column object in a table that contains information needed by replication.
Public classReplicationDatabaseRepresents a publication or subscription database in a replication topology.
Public classReplicationDatabaseCollectionRepresents a collection of ReplicationDatabase objects.
Public classReplicationMonitorMonitors a replication server.
Public classReplicationObjectAbstract class that is the base class for all classes in the Replication Management Objects (RMO) programming interface.
Public classReplicationSchemaBoundViewRepresents a schema-bound view and contains information needed by replication.
Public classReplicationServerRepresents 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.
Public classReplicationStatusAndWarningRepresents replication agent status information and threshold monitor warnings.
Public classReplicationStoredProcedureRepresents information on a stored procedure object that is required by replication.
Public classReplicationTableRepresents information on a table object that is required by replication.
Public classReplicationUserDefinedAggregateRepresents a user-defined aggregate function and contains information needed by replication.
Public classReplicationUserDefinedFunctionRepresents a user-defined function and contains information needed by replication.
Public classReplicationViewRepresents information on a view object that is required by replication.
Public classSubscriberSubscriptionReturns information about a subscription.
Public classSubscriptionRepresents 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.
Public classSubscriptionBackupInformationRepresents information required to initialize a subscription from a backup.
Public classSynchronizationPartnerRepresents an alternate Publisher used to synchronize a subscription to a merge publication.
Public classTracerTokenRepresents tracer token information.
Public classTransArticleRepresents an article in a transactional publication.
Public classTransArticleCollectionRepresents a collection of TransArticle objects.
Public classTransConflictCountRepresents returned conflict information for a table article in a publication that supports queued updating subscriptions.
Public classTransPublicationRepresents a transactional publication.
Public classTransPublicationCollectionRepresents a collection of TransPublication objects.
Public classTransPullSubscriptionRepresents a pull subscription to a transactional publication.
Public classTransPullSubscriptionCollectionRepresents a collection of TransPullSubscription objects.
Public classTransSubscriptionRepresents a push subscription to a transactional or snapshot publication.
Public classTransSubscriptionCollectionRepresents a collection of TransSubscription objects.

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

Public enumerationAddColumnOptionEnumerates the options for adding a column to a table published in an existing publication.
Public enumerationAgentProfileTypeOptionIndicates whether a replication agent profile is system-defined or user-defined.
Public enumerationAgentTypeEnumerates the various types of replication agents.
Public enumerationArticleDatatypeMappingOptionsSpecifies 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.
Public enumerationArticleOptionsEnumerates the type of database objects that can be published by replication.
Public enumerationAuthenticationMethodEnumerates values that specify the supported HTTP authentication methods for Web synchronization.
Public enumerationAutomaticReinitializationPoliciesEnumerates default behaviors when reinitializing subscriptions to a merge publication.
Public enumerationCheckPermissionOptionsEnumerates the table-level permissions that are verified when the Merge Agent applies changes at the Publisher.
Public enumerationCommandOptionsEnumerates options that control how changes are propagated for transactional articles.
Public enumerationConflictPolicyOptionEnumerates options for selecting the winning row when conflicts occur during synchronization of an updating subscription to a transactional publication.
Public enumerationCreationScriptOptionsEnumerates schema option values for published articles.
Public enumerationDatabaseCompatibilityLevelEnumerates the versions of Microsoft SQL Server that are supported for database compatibility with Microsoft SQL Server 2005.
Public enumerationDdlReplicationOptionsEnumerates whether data definition language (DDL) changes to published tables are replicated.
Public enumerationDtsPackageLocationOptionEnumerates options for the location of the Data Transformation Services (DTS) package.
Public enumerationFailoverModeEnumerates the options available for an updating Subscriber to propagate changes back to the Publisher.
Public enumerationFilterTypesEnumerates values that specify the type of filters used in merge articles.
Public enumerationIdentityRangeManagementOptionEnumerates options for managing identity column range assignments in tables published using merge replication and transactional replication with updating Subscribers.
Public enumerationInitialSyncTypeEnumerates the data file formats supported for the initial snapshot.
Public enumerationMergeArticleStateEnumerates the supported status settings for a merge article.
Public enumerationMergeSessionDetailTypeEnumerates parts of a Merge Agent session being monitored.
Public enumerationMergeSessionPhaseEnumerates the phase of a Merge Agent session.
Public enumerationMergeSessionStatusEnumerates the status of a Merge Agent session.
Public enumerationMergeSubscriberTypeEnumeration additional types of subscriptions supported by merge replication.
Public enumerationMonitorCacheRefreshPolicyInfrastructure.
Public enumerationPartitionGroupsOptionEnumerates values that determine whether a merge publication uses precomputed partitions.
Public enumerationPartitionOptionsEnumerates the ways in which data in an article is partitioned amongst subscriptions when the merge publication uses a parameterized row filter.
Public enumerationPreCreationOptionEnumerates the commands that are executed prior to subscription initialization when a published table already exists in the subscription database.
Public enumerationPublicationAttributesEnumerates supported publication properties.
Public enumerationPublicationCompatibilityLevelEnumerates product version values that are used by merge replication to determine which features can be used by publications in a given database.
Public enumerationPublicationTypeEnumerates the supported types of replication used to publish a database.
Public enumerationQueueOptionEnumerates the type of queuing available to a transactional publication with updating Subscribers.
Public enumerationReplicationSecurityModeSpecifies the supported security modes used by updating Subscribers when connecting to the Publisher.
Public enumerationReplicationStatusSpecifies the status of a replication agent job.
Public enumerationReplicationWarningsEnumerates the supported replication threshold monitor warning values.
Public enumerationResynchronizeTypeEnumerates values that specify the changes to apply when a merge subscription is resynchronized.
Public enumerationRetentionPeriodUnitsEnumerates values that specify the units for the retention period.
Public enumerationScheduleConstantEnumerates constant values used to set replication schedules.
Public enumerationScheduleFrequencySubDayEnumerates values that specify a smaller scheduling unit for specific schedule frequencies.
Public enumerationScheduleFrequencyTypeEnumerates the types of frequencies used when scheduling a replication agent job.
Public enumerationScheduleRelativeIntervalsEnumerates values that represent the frequency of a replication agent schedule relative to the ScheduleFrequencyType.
Public enumerationScriptOptionsEnumerates options for generating scripts that are used to create or remove replication objects.
Public enumerationStateEnumerates the values that represent the status of a publication.
Public enumerationSubscriberTypeEnumerates the types of data sources that can be a Subscriber to a publication.
Public enumerationSubscriberUploadOptionsEnumerates merge article options for updates made at a Subscriber with a client subscription.
Public enumerationSubscriptionBackupDeviceTypeEnumerates backup devices that can be used to initialize a subscription.
Public enumerationSubscriptionResultOptionEnumerates options for returning monitored subscriptions.
Public enumerationSubscriptionStateEnumerates options for the status of a subscription.
Public enumerationSubscriptionSyncTypeEnumerates options for how the initial synchronization is performed for a subscription.
Public enumerationTransSubscriberTypeEnumerates the updating behaviors for subscriptions to transactional publications.
Public enumerationValidationMethodEnumerates methods supported for rowcount validation of transactional publications.
Public enumerationValidationOptionEnumerates the types of data validation supported by replication.
Public enumerationVerifyResolverSignatureOptionEnumerates 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.

Community Additions