TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

PublicationCompatibilityLevel Enumeration

 

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

Publication is compatible with only the latest version of SQL Server.

Version100

Publication is compatible back to SQL Server 2008.

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.

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

Return to top
Show:
© 2016 Microsoft