http://www.red-gate.com/products/SQL_Data_Compare/index.htm

SQL Data Compare is used for automating data migrations, analyzing corrupted data, restoring row-level data from backups, compiling audit trails of missing or changed data, and SQL scripts under source control. It's the industry standard tool for comparing and synchronizing the contents of two databases because it's very reliable and also very fast.

With SQL Data Compare's granular SQL change-scripts you can now restore damaged or missing data to a single row, without the need for a full database recovery, and that means you can fix database problems even faster.
  • Compare the contents of two databases
  • Automatically synchronize your data
  • Work with SQL scripts, backups, or live databases
  • Compare and synchronize both schemas and data, moving seamlessly from SQL Compare to SQL Data Compare
  • Row-level data restore
  • Full support for SQL Server 2008

You would..
Share