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).
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.
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.
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:
- A Microsoft Windows operating system;
- The Microsoft .NET Framework 2.0 or greater (Download it now from Microsoft.com – Approximately 22MB).
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.
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.
Table Diff also allows you to filter which records you want to display on the grid, as shown in the following screenshot.
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!
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.
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 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.
When defining a custom index, Table Diff will automatically check for you that the attributes specified uniquely identify each record in both tables.
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.
Want to know more?
If you have any questions regarding Table Diff, please drop us an e-mail at firstname.lastname@example.org, 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.