PublicationCompatibilityLevel Enum

Definition

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

public enum class PublicationCompatibilityLevel
public enum PublicationCompatibilityLevel
type PublicationCompatibilityLevel = 
Public Enum PublicationCompatibilityLevel
Inheritance
PublicationCompatibilityLevel

Fields

LatestVersion 100

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

Version100 100

Publication is compatible back to SQL Server 2008.

Version70 10

Publication is compatible back to SQL Server 7.0.

Version70SP1 20

Publication is compatible back to SQL Server 7.0 Service Pack 1.

Version70SP2 30

Publication is compatible back to SQL Server 7.0 Service Pack 2.

Version70SP3 35

Publication is compatible back to SQL Server 7.0 Service Pack 3.

Version80 40

Publication is compatible back to SQL Server 2000.

Version80SP1 50

Publication is compatible back to SQL Server 2000 Service Pack 1.

Version80SP3 60

Publication is compatible back to SQL Server 2000 Service Pack 3.

Version90 90

Publication is compatible back to SQL Server 2005.

Remarks

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

Applies to

See also