CompareTool

CompareTool

Table Data Comparison

CompareTool is included in the following products

AtanaSuite 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 AtanaSuite CompareTool

Feature
Table Data Comparison
Compare data in Teradata tables 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. Utilizes fastest protocols available for performing these comparisons even across servers quickly and easily. AtanaSuite Active Script and Active Server enabled!
Feature
Intelligent Comparison Logic
Compares data at the row level for complete difference notification.
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
Results Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Feature
Table Selection
Select the table to compare and have CompareTool do the work!
Feature
Column Filter
Only compare the columns you select with this feature.
Feature
Comparison Lock
Specify type of lock to be used when executing comparison.
Feature
Auto Apply
Have CompareTool automatically apply the sync script upon comparison completion.
Feature
Tool-to-Tool Integration
The AtanaSuite 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
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 with stop the comparison.
Feature
Data Filter
Restrict comparison to certain portions of data by using this filter.
Feature
Color-coded Results Display
Easily identify exact differences within the comparison results.
Feature
Active Script and Server Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution and modification. Purchase AtanaSuite Active Server and take advantage of its centralized job repository, scheduling, execution, monitoring and reporting features.