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)

Syntax

'Declaration
Public Enumeration PublicationCompatibilityLevel
'Usage
Dim instance As PublicationCompatibilityLevel
public enum PublicationCompatibilityLevel
public enum class PublicationCompatibilityLevel
type PublicationCompatibilityLevel
public enum PublicationCompatibilityLevel

Members

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.

Remarks

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

This namespace, class, or member is supported only in version 2.0 of the .NET Framework.