A simple, fast and reliable tool
DbCmp is a simple, fast and reliable tool which lets you compare and synchronize SQL Server data.

Features
Databases, tables and columns schemas intelligent recovery
Intelligent suggest mechanism of comparing pairs of tables
Intelligent key(s) suggest mechanism
Multiple keys use possibility
Generating synchronization scripts
Running synchronization scripts
Support for Blob/Image type columns
Simple and handy user interface
Select pair of databases to compare: a source database and a mirror database.
Choose pairs of tables to compare or use suggest mechanism.
Choose key columns or use suggest keys mechanism.
Compare and see a comparison report including: missing and additional rows, same and different data.
Save a synchronization script(s) as a sql script file(s) or just run synchronization. you can free download DbCmp 1.0 now.