SQL Data Compare
some of the features
- Compare the contents of two databases
- Automatically synchronize your data
- Compare database backup files as if they were live databases
- Row-level data restore
- Full support for SQL Server 2008
SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups and compiling audit trails of missing or changed data. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast.
Latest version 7.0
Reference: http://www.red-gate.com/products/SQL_Data_Compare/index.htm