.png)
Microsoft.SqlServer.Replication Namespace
SQL Server 2008 R2
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.
| 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. |
| 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. |
| 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. |
