Table Diff is a smart database comparison tool for SQL Server that allows database administrators and software developers to identify and eliminate data differences between database tables. Table Diff works with tables that might be located on disparate SQL Servers, allows identifying data differences such as missing records and different records (records with matching unique key and at least one mismatching non-key attribute), and generating synchronization scripts in SQL. Table Diff also allows to quickly synchronizing rows, columns and cells values by simply right-clicking on the object to synchronize. Table Diff solves one problem very well, and does not cost a fortune. Table Diff works with SQL Server 2000, 2005 and 2008. Data comparison can be performed between different versions of Microsoft SQL Server (e.g. compare a table on a Microsoft SQL Server 2000 to a table in Microsoft SQL Server 2008 as part of a migration).
