Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.