About the Compare Editor - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
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
The following is an example of a comparison of the DDL text of two compared databases in the Compare Editor.


The following is an example of the DDL text comparison for two 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
The Next Difference and Previous Difference functions in the toolbar allow you 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
The Next Change and Previous Change functions in the toolbar allow you 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.