United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Replication)

Microsoft.SqlServer.Replication

AddColumnOption Enumeration

AgentJobHistoryInfo Class

AgentProfile Class

AgentProfileParameter Class

AgentProfileParameterInfo Class

AgentProfileTypeOption Enumeration

AgentType Enumeration

Article Class

ArticleConflict Class

ArticleDatatypeMappingOptions Enumeration

ArticleOptions Enumeration

AuthenticationMethod Enumeration

AutomaticReinitializationPolicies Enumeration

BusinessLogicHandler Class

CheckPermissionOptions Enumeration

CommandOptions Enumeration

ConflictPolicyOption Enumeration

ConnectionSecurityContext Class

CreationScriptOptions Enumeration

CustomResolver Class

DatabaseCompatibilityLevel Enumeration

DdlReplicationOptions Enumeration

DistributionArticle Class

DistributionArticleCollection Class

DistributionDatabase Class

DistributionDatabaseCollection Class

DistributionPublication Class

DistributionPublicationCollection Class

DistributionPublisher Class

DistributionPublisherCollection Class

DistributionSubscription Class

DistributionSubscriptionCollection Class

DtsPackageLocationOption Enumeration

FailoverMode Enumeration

FilterTypes Enumeration

HeterogeneousColumn Class

HeterogeneousTable Class

IConnectionSecurityContext Interface

IdentityRangeInfo Class

IdentityRangeManagementOption Enumeration

InitialSyncType Enumeration

IProcessSecurityContext Interface

IReplicationDBObject Interface

LastValidationDateTime Class

LightPublication Class

MergeArticle Class

MergeArticleCollection Class

MergeArticleState Enumeration

MergeConflictCount Class

MergeDynamicSnapshotJob Class

MergeJoinFilter Class

MergePartition Class

MergePublication Class

MergePublicationCollection Class

MergePullSubscription Class

MergePullSubscriptionCollection Class

MergeSessionDetail Class

MergeSessionDetailType Enumeration

MergeSessionError Class

MergeSessionPhase Enumeration

MergeSessionStatus Enumeration

MergeSessionSummary Class

MergeSubscriberMonitor Class

MergeSubscriberType Enumeration

MergeSubscription Class

MergeSubscriptionCollection Class

MonitorCacheRefreshPolicy Enumeration

MonitorThreshold Class

PartitionGroupsOption Enumeration

PartitionOptions Enumeration

PendingCommandInfo Class

PreCreationOption Enumeration

Publication Class

PublicationAccess Class

PublicationArticle Class

PublicationAttributes Enumeration

PublicationCompatibilityLevel Enumeration

PublicationMonitor Class

PublicationMonitorCollection Class

PublicationType Enumeration

PublisherConnectionSecurityContext Class

PublisherMonitor Class

PublisherMonitorCollection Class

PullSubscription Class

QueueOption Enumeration

RegisteredSubscriber Class

RegisteredSubscriberCollection Class

ReplicationAgentSchedule Class

ReplicationBaseCollection Class

ReplicationColumn Class

ReplicationDatabase Class

ReplicationDatabaseCollection Class

ReplicationMonitor Class

ReplicationObject Class

ReplicationSchemaBoundView Class

ReplicationSecurityMode Enumeration

ReplicationServer Class

ReplicationStatus Enumeration

ReplicationStatusAndWarning Class

ReplicationStoredProcedure Class

ReplicationTable Class

ReplicationUserDefinedAggregate Class

ReplicationUserDefinedFunction Class

ReplicationView Class

ReplicationWarnings Enumeration

ResynchronizeType Enumeration

RetentionPeriodUnits Enumeration

ScheduleConstant Enumeration

ScheduleFrequencySubDay Enumeration

ScheduleFrequencyType Enumeration

ScheduleRelativeIntervals Enumeration

ScriptOptions Enumeration

State Enumeration

SubscriberSubscription Class

SubscriberType Enumeration

SubscriberUploadOptions Enumeration

Subscription Class

SubscriptionBackupDeviceType Enumeration

SubscriptionBackupInformation Class

SubscriptionResultOption Enumeration

SubscriptionState Enumeration

SubscriptionSyncType Enumeration

SynchronizationPartner Class

TracerToken Class

TransArticle Class

TransArticleCollection Class

TransConflictCount Class

TransPublication Class

TransPublicationCollection Class

TransPullSubscription Class

TransPullSubscriptionCollection Class

TransSubscriberType Enumeration

TransSubscription Class

TransSubscriptionCollection Class

ValidationMethod Enumeration

ValidationOption Enumeration

VerifyResolverSignatureOption Enumeration

Minimize

This topic has not yet been rated - Rate this topic

PublicationCompatibilityLevel Enumeration

SQL Server 2012

Enumerates product version values that are used by merge replication to determine which features can be used by publications in a given database.

Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public enum PublicationCompatibilityLevel

	Member name	Description
	Version70	Publication is compatible back to SQL Server 7.0.
	Version70SP1	Publication is compatible back to SQL Server 7.0 Service Pack 1.
	Version70SP2	Publication is compatible back to SQL Server 7.0 Service Pack 2.
	Version70SP3	Publication is compatible back to SQL Server 7.0 Service Pack 3.
	Version80	Publication is compatible back to SQL Server 2000.
	Version80SP1	Publication is compatible back to SQL Server 2000 Service Pack 1.
	Version80SP3	Publication is compatible back to SQL Server 2000 Service Pack 3.
	Version90	Publication is compatible back to SQL Server 2005.
	Version100	Publication is compatible back to SQL Server 2008.
	LatestVersion	Publication is compatible with only the latest version of SQL Server.

After a publication is created, the compatibility level can be increased but cannot be decreased.

Reference

Microsoft.SqlServer.Replication Namespace

MergePublication

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.