CompareTool

CompareTool

Table and View Data Comparison

CompareTool is included in the following subscription product


DataGEM CompareTool makes it a snap to compare data in different databases, even on different servers. Great for keeping your test or development servers in sync with production.

CompareTool is particularly useful for synchronizing test, staging and production data!

CompareTool eliminates the guessing game and chasing-down hunches to locate data differences.

Easily connect to reference and comparison databases, specify the tables and columns you want to compare and let CompareTool do the work. CompareTool automatically generates a script to synchronize the two tables!

Using CompareTool is as easy as point and click: select databases and tables from drop-down lists, and click checkboxes for columns and options. Tabs at the top allow for quick navigation to main areas. Automatically generates sync script and provides color-coded SQL for preview!

CompareTool Screenshots

Click on an image below to expand.

CompareTool

Options

CompareTool

Results

CompareTool

Sync Script

CompareTool Features

Some of the key features within DataGEM CompareTool

Feature
Table and View Data Comparison
Compare data in tables and views with ease and display easy to read results that can be saved to Excel for testing and auditing purposes. Automatically generate a sync script to bring the comparison table in sync with the reference. Even perform these comparisons across servers quickly and easily.
Feature
Sync Script Generation
All the differences found may be corrected with the sync script generated as part of the comparison. Save this to a file or send to QueryTool for editing or execution.
Feature
Color-coded Results Display
Easily identify exact differences within the comparison results.
Feature
Table and View Selection
Select the table or view to compare and have CompareTool do the work!
Feature
Column Filter
Only compare the columns you select with this feature.
Feature
Tool-to-Tool Integration
The DataGEM environment is designed to help get you to the right tool for the job by providing toolbar buttons that enable context aware loading of information from one tool to another.
Feature
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Cross Server Compare
Sophisticated comparison logic even works across servers.
Feature
Differences Limit
Control the execution of the comparison by specifying a differences limit that if exceeded will stop the comparison.
Feature
Data Filter
Restrict comparison to certain portions of data by using this filter.
Feature
Active Script Enabled
Save commonly executed operations as an Active Script job that can be opened later within JobTool for execution, modification and scheduling.