Comparing databases on different SQL Server versions
Published 13 December 2022
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.