PublicationCompatibilityLevel Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 PublicationCompatibilityLevelpublic enum PublicationCompatibilityLeveltype PublicationCompatibilityLevel = Public Enum PublicationCompatibilityLevel- Inheritance
-
PublicationCompatibilityLevel
Fields
| Name | Value | Description |
|---|---|---|
| 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. |
| LatestVersion | 100 | Publication is compatible with only the latest version of SQL Server. |
| Version100 | 100 | Publication is compatible back to SQL Server 2008. |
Remarks
After a publication is created, the compatibility level can be increased but cannot be decreased.