These pages cover SQL Compare 13, which is not the latest version. Help for other versions is also available.
Comparing databases on different SQL Server versions
Published 04 June 2013
This topic provides additional information if you're comparing databases on different versions of Microsoft SQL Server.
Comparing SQL Server 2005 compatibility level 80 databases
If a SQL Server 2005 database has its compatibility level set to 80, it conforms to strict rules for views, stored procedures, functions, and DML triggers. Therefore, comparisons and deployments may fail.
Comparing SQL Server 2005 compatibility level 90 databases
If a SQL Server 2008 database has its compatibility level set to 90, it conforms to strict rules for views, stored procedures, functions, and DML triggers. Therefore, comparisons and deployments may fail.
