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 | |
|---|---|---|
| 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. |
Remarks
After a publication is created, the compatibility level can be increased but cannot be decreased.