Identify & eliminate data differences

No more manual checking and fixing

Generate synchronization scripts

And execute them whenever you’re ready

Migrate data between environments

Your testers will love using real data from production

Verify data migrations

Even between different versions of SQL Server

Identify replication issues

Your support team will love this

Synchronize records, columns and cells

Right-click on a column or a row to synchronize all values

Identify data differences

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 analyses the records in two tables and will identify data differences such as missing records and different records (e.g. records having matching key but different non-key attributes).

ComparisonGrid

Differences are highlighted in green. A little green arrow indicates the default synchronization action. You can change the direction for a specific value or for the entire record by clicking on the green arrow. You can also tell Table Diff to ignore a specific difference.

Eliminate data differences, fast!

Simply right-click on a different column, row or cell to update it instantly. You can also generate the SQL required to synchronize only a specific column, row or cell.

Menu shown when right-clicking on a row with differencies.

Generate synchronization scripts

Want to eliminate all differences in one go or prepare the work for later use? Generate the Synchronization Script by clicking the “Generate SQL” button.

Once the "Generate SQL" button is clicked, the SQL script is generated and displayed to the user.

Helps in many scenarios

We have identified a number of scenarios where Table Diff can help:

  • As part of the deployment process, verify that data was migrated successfully;
  • As part of the deployment process, copy the content of new tables in the development databases to the live databases;
  • To facilitate testing, update your development or staging databases with real data from the live databases;
  • As part of an upgrade, migrate data between Microsoft SQL Server 2000, MSDE 2000, 2005 and 2008;
  • Help identify replication issues (e.g. data missing in a specific instance of SQL Server).

Here you can find more detailed explanations of how Table Diff is used.

Works with the most common versions of Microsoft SQL Server

Table Diff has been tested on the most popular versions of Microsoft SQL Server:

  • Microsoft SQL Server 2000 (All Editions);
  • Microsoft SQL Server Desktop Engine 2000;
  • Microsoft SQL Server 2005 (All Editions);
  • Microsoft SQL Server 2008 (All Editions).

Runs on the most common versions of Microsoft Windows

Table Diff has been tested on Windows XP, Windows Vista, Windows 7, Windows Server 2003 and Windows Server 2008.

In order to run Table Diff, you will need:

Quickly select records to synchronize

The Select menu allows you to quickly select the records that you want to synchronize. This is very useful when you have two tables with many differences and you only want to synchronize some of the records.

The Select Menu in Table Diff

Quickly find different records

The Find menu allows you to quickly navigate to the next or to the previous different record displayed on the comparison grid. This feature comes handy when you have many records displayed on the grid, and only few of them are different.

The Find Menu in Table Diff

Table Diff also allows you to filter which records you want to display on the grid, as shown in the following screenshot.

Table Diff allows you to specify which records you want to see in the comparison grid

The UI runs on a separate thread

In Table Diff, long running operations are always performed on a separate thread, so that you can cancel the operation, if you want to. No CTRL+ALT+DEL required with Table Diff!

In Table Diff, long running operations are performed on a separate thread

Automatic updates, if you want to.

Table Diff will silently check for updates when you launch it. You can also check for updates using the Help -> Check for updates menu. Obviously, you can tell Table Diff not to silently check for updates at start up.

Table Diff can automatically update itself, if you want to.

The Table Diff updater makes a backup of your current version, so that if anything goes wrong during the backup, the old version is automatically restored. Settings and other customization (always stored in easy-to-read XML files) are never overwritten.

Flexible column mapping

Table Diff can compare tables having different column names and facilitates column mapping by automatically mapping columns with the same name and with the same data type.

Table Diff features allows mapping columns with different names

Indexes

Table Diff automatically retrieves the list of indexes from the two tables, so that you can easily define which one of them you would like to use for the comparison. Table Diff also allows you to define a customer index on the fly. Defining a custom index will not alter the tables.

Table Diff automatically retrieves indexes from the tables

When defining a custom index, Table Diff will automatically check for you that the attributes specified uniquely identify each record in both tables.

Error management

Let’s hope it does not happen, however, if an error occurs during the execution of Table Diff, you will get a brief explanation and a lot of information can be found in the application event log. This should make our life easier in case something goes wrong.

Lots of keyboard shortcuts

Last but not least, Table Diff comes with lots of keyboard shortcuts, which make things easier when using the tool regularly.

Table Diff Keyboard Shortcuts

Want to know more?

If you have any questions regarding Table Diff, please drop us an e-mail at info@volpet.com, ping us on Twitter or request support through our support pages. We’ve also put together a walkthrough, which you might find useful to understand how to use Table Diff.