AtanaSuite Delta
AtanaSuite Delta is a Microsoft Windows automation program that compares Teradata objects to detect differences. It accepts and outputs XML or JSON files to simplify integration with third party automated processes, schedulers and applications.

AtanaSuite Delta is run from the Windows command prompt and utilizes the same sophisticated delta logic for object comparisons found in the AtanaSuite family of desktop graphical user interface products. It supports several types of comparison analysis operations and can even automatically apply the sync script it creates to bring your objects in sync!

Delta Screenshots

Click on an image below to expand.

AtanaSuite Delta XML Input File

Input File - XML

AtanaSuite Delta JSON Input File

Input File - JSON

Command Prompt

Command Prompt Window

AtanaSuite Delta JSON Results

Results File - JSON

AtanaSuite Delta XML Results

Results File - XML

AtanaSuite Delta Sync

Sync Script

Delta Features

Some of the key features within AtanaSuite Delta.

Feature
XML and JSON Support
Provide input using either XML or JSON and generate matching comparison operation results.
Feature
Recursive Object Type Delta Comparison
Include children databases in the object type comparison operation.
Feature
Name Substitution
Partial match, name and regular expression substitution of object names to handle differences between databases and systems.
Feature
Individual Object Sync or Replacement SQL
Access individual object sync or replacement SQL.
Feature
Results Summary
Start and end times as well as object, differences, error and warning counts to quickly determine if further investigation is needed
Feature
Performance Options
Turn off verbose logging or use cached object definitions to speed comparison operation performance.
Feature
Multiple Delta Comparison Operations
Choose between object type, recursive object type, individual object and roles and profiles comparison operations.
Feature
Table Replacement Support
Generate table replacement scripts instead of ALTER when needed or by selection.
Feature
Server Role and Profile Delta Comparison
Compare roles and profiles between database servers.
Feature
Sync Script
Generates a complete sync script for all objects compared that contains the SQL needed to bring the target in sync with the source.
Feature
Common Object Attribute Exclusions
Ignore case and whitespace in object definitions. Exclude comments, space, fallback, journal and may other common object attributes that tend to differ by reason across databases and servers.
Feature
Object Definition Caching
Cache object definitions to improve comparison operation performance.
Feature
Developed for Automation
Command-line application that accepts and outputs industry standard formatted results that simplifies integration into automated processes.
Feature
Individual Object Selection Delta Comparison
Select individual database, role and profile objects for comparing.
Feature
Differences Limit
Stop comparison operation if number of differences exceeds this threshold.
Feature
Verbose Logging
Displays almost every detail of the Delta operation.
Feature
Stats Comparison
Compare and detect statistics differences.
Feature
Auto Apply
Automatically apply the generated sync script to bring your objects in sync.
Feature
Teradata CLI Database Connectivity
Tested to be the fastest mechanism for database information access and retrieval.