Comparing databases on different SQL Server versions

When comparing databases on different SQL Server versions, please keep in mind the following:

  • Comparing SQL Server 2005 compatibility level 80 databases

If the compatibility level of an SQL Server 2005 database is set to 80, it conforms to strict rules for views, stored procedures, functions, and DML triggers. Thus, comparison and synchronization may fail.

  • Comparing SQL Server 2008 compatibility level 90 databases

If the compatibility level of an SQL Server 2008 database is set to 90, it conforms to strict rules for views, stored procedures, functions, and DML triggers. Thus, comparison and synchronization may fail.