Export (0) Print
Expand All
Expand Minimize

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)

public enum PublicationCompatibilityLevel

Member nameDescription
Version70Publication is compatible back to SQL Server 7.0.
Version70SP1Publication is compatible back to SQL Server 7.0 Service Pack 1.
Version70SP2Publication is compatible back to SQL Server 7.0 Service Pack 2.
Version70SP3Publication is compatible back to SQL Server 7.0 Service Pack 3.
Version80Publication is compatible back to SQL Server 2000.
Version80SP1Publication is compatible back to SQL Server 2000 Service Pack 1.
Version80SP3Publication is compatible back to SQL Server 2000 Service Pack 3.
Version90Publication is compatible back to SQL Server 2005.
Version100Publication is compatible back to SQL Server 2008.
LatestVersionPublication is compatible with only the latest version of SQL Server.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft