Image

CompareTool

Teradata and ODBC Data Comparison

Available in

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!

Tool Screenshots

Screenshots of CompareTool in action.

Key Features

Some of the key features found in CompareTool.

CompareTool Screenshots

Click on an image below to expand.

Image

Options

Image

Results

Image

Sync Script

CompareTool Features

Some of the key features within CompareTool.

Badge ImageTable 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.
Badge ImageIntelligent Comparison Logic
Compares data at the row level for complete difference notification.
Badge ImageSync 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.
Badge ImageResults Export
Available throughout the product that provides exporting results to the most popular formats including Excel.
Badge ImageTable Selection
Select the table to compare and have CompareTool do the work!
Badge ImageColumn Filter
Only compare the columns you select with this feature.
Badge ImageComparison Lock
Specify type of lock to be used when executing comparison.
Badge ImageAuto Apply
Have CompareTool automatically apply the sync script upon comparison completion.
Badge ImageTool-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.
Badge ImageCross Server Compare
Sophisticated comparison logic even works across servers.
Badge ImageDifferences Limit
Control the execution of the comparison by specifying a differences limit that if exceeded with stop the comparison.
Badge ImageData Filter
Restrict comparison to certain portions of data by using this filter.
Badge ImageColor-coded Results Display
Easily identify exact differences within the comparison results.
Badge ImageActive Script Enabled
Save commonly executed operations as an AtanaSuite Active Script job that can be opened later within JobTool for execution, modification and scheduling.

AtanaSuite

AtanaSuite is a proven leader in development, management, query, visualization, compression and synchronization productivity products for popular databases including Teradata and Vantage!