DeltaTool

DeltaTool

Database Object Comparison

DeltaTool is included in the following products


AtanaSuite DeltaTool eliminates the guessing game and time-consuming work associated with comparing, locating and correcting database Teradata object differences. It can quickly determine where objects differ, provide detailed results and create the necessary DDL to get them in sync.

Using DeltaTool is as easy as connect, select, specify and click! Just connect to the servers, select the databases, specify delta options and click the execute button. DeltaTool will compare the database objects, display a progress log, compile a complete listing of the differences detected, generate a sync script and even apply it automatically!

If additional functionality like name substitution, individual object selection, recursive database comparison, or server roles and profiles comparison is needed, then be sure to check out the version of DeltaTool found in AtanaSuite Expert and AtanaSuite Enterprise.

AtanaSuite Professional DeltaTool Screenshots

Click on an image below to expand.

DeltaTool

Databases

DeltaTool

Options

DeltaTool

Results

AtanaSuite Expert and Enterprise DeltaTool Screenshots

Click on an image below to expand.

DeltaTool

Databases

DeltaTool

Objects

DeltaTool

Options

DeltaTool Features

Some of the key features within AtanaSuite DeltaTool

Feature
Robust Database Object Comparison
A powerful and sophisticated Teradata database object comparison engine beneath a simple point-n-click GUI quickly identifies even the smallest of differences. Multiple object type selections and options provided. Delivers detailed results and sync script for review and application. AtanaSuite Active Script and Active Server enabled as well!
Feature
Intelligent Comparison Logic
Compares objects at the attribute level for complete difference notification.
Feature
Cross Server Compare
Sophisticated comparison logic even works across servers.
Feature
Object Type Attribute Filter
Include or exclude certain object attributes that could be different across databases or servers.
Feature
Object Name Comparison Filter
Limit comparison to named objects by using the name comparison filter.
Feature
Differences Limit
Control the execution of the comparison by specifying a differences limit that if exceeded with stop the comparison.
Feature
AtanaSuite Delta Viewer
Individually compare differences side-by-side with the nifty AtanaSuite Delta Viewer.
Feature
Verbose Logging
Select this option to have DeltaTool provide detailed information in the log.
Feature
Roles and Profiles Comparison
Compare roles and profiles between different Teradata servers. Available in Expert and Enterprise products.
Feature
Database Selection
Select the databases to compare and have DeltaTool do the work!
Feature
Recursive Database Comparison
Compare databases within databases by selecting this option. Available in Expert and Enterprise products.
Feature
Ignore Case
Perform case insensitive comparison of object bodies when needed.
Feature
Statistics Comparison
Quickly identify differences with statistics definitions by selecting this option.
Feature
Name Substitution
Name, partial match and even regular expression support within this option enables DeltaTool to replace specified names prior to comparing to help user control real difference identification between objects. Available in Expert and Enterprise products.
Feature
Table Swap
Automatically generates table swap code for table differences that cannot be applied via a standard Teradata table alter statement. AtanaSuite even includes the privileges!
Feature
Auto Apply
Have DeltaTool automatically apply the sync script upon comparison completion. Available in Expert and Enterprise products.
Feature
Active Script and Server Enabled
Save commonly executed SQL, DDL, DCL, DML and related statements 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.
Feature
Object Filter
Only compare the objects you select with this feature. Available in Expert and Enterprise products.
Feature
Object Type Filter
Only compare tables, views or other object types by using this filter.
Feature
Ignore Whitespace
Eliminate potential non-critical difference identification with this option.
Feature
Row Count
Get basic data related differences by selecting the row count option.
Feature
Comparison Log
Identifies and displays real-time progression of DeltaTool comparison with timestamps for auditing purposes.
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
Performance Optimizations
Additional option available to use cache to optimize performance.
Feature
Results Column Filter
Refine your results display by specifying column filters.
Feature
Results Export
Save results to Excel for use elsewhere.
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.