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
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

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
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.