About the Compare Editor - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-10
dita:mapPath
pfg1542649412202.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

The Compare Editor compares the Data Definition Language (DDL) text of two database objects and shows the DDL for each object side-by-side in a split window. Any differences in text or changed elements between the two objects are high-lighted in the editor. You can browse the text or use the toolbar to review next/previous differences and next/previous changed elements.

Types of objects you can compare are:
  • Database
  • User
  • Table
  • Stored Procedure
  • Macro
  • User-defined Function
  • View
Comparison of DDL Text of Two Databases

DDL Text Comparison of Table Objects

Referenced Object
The object you selected in the Data Source Explorer as the object to compare with another object. The Compare SQL Objects wizard presents only objects for comparison that are the same object type as the referenced object. The DDL text for this object displays in the left pane of the Compare Editor.
Compared to Object
The object you selected in the Compare SQL Objects wizard for comparison with the referenced object. The DDL text for this object displays in the right pane of the Compare Editor.
Next and Previous Differences
Use the Next Difference () and Previous Difference () functions to review the differences between the two displayed objects in sequence of occurrence. The editor highlights the next or previous difference as you review and compare the DDL text in the two object panes.
Next and Previous Change
Use the Next Change () and Previous Change () functions to review element changes in the two compared objects. The editor highlights the next or previous change as you review and compare the DDL elements.