SQL Delta allows you to compare different databases so that you can
identify differences between large amounts of data within seconds. You
no longer need to manually export databases and compare in text editors
(or text comparison tools). You remove the uncertainty and inaccuracies
associated with eye balling data and drastically reduce the amount of
time taken to spot problems.

Using SQL Delta to compare both schemas and data between two
Microsoft SQL databases will help you identify differences between
tables, views, stored procedures and other database objects. As part of
application upgrade testing this tool is invaluable in helping you see
the differences between a clean install of a database and a version of a
database that has been upgraded (helping you ensure that the schema for
an upgraded database is identical to a cleanly installed database).

Implementing SQL Delta not only increases the accuracy of any
database comparison efforts but easily saves significant amounts of time
and effort. In addition to this SQL Delta also:

• Compare different database objects - Compare database structure and all scheme objects between two databases, with simple to interpret difference displays.
• Perform comparisons offline - Create snapshots of database schemas in order to perform comparisons offline and create synchronization scripts.
• Create difference reports - Produce extensive reports detailing entire database schemas in addition to comprehensive comparison reports.
• Clear highlighting - See the
  differences between inline data for rows in the same context with same
  data. This is essential in helping see why and where data differences
  occur.

Compares databases in Microsoft SQL Server 7, 2000, 2005 and 2008
(limited support provided for SQL Server 2008). System requirements;
Microsoft Windows 2000, XP, Vista or higher, 50mb disk space, 256mb RAM,
Microsoft SQL Server 7 or 2000, 2005 and MDAC 2.6 or higher (you can
download from Microsoft for free if needed)