About Comparing Objects | Teradata Studio - About Comparing Objects - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
The Compare SQL Objects wizard lets you compare:
  • Data Definition Language (DDL) text of two database objects of the same type
  • Vantage objects with other data objects of the same type
  • Aster objects with other Aster objects of the same type

The wizard guides you through the selection of the object you want to compare. Depending on the object type you selected in the Data Source Explorer, you can select an object of the same type. For example, if you select a Table object in Data Source Explorer, you can only choose a Table object to compare with it.

Optionally, for Teradata objects, you can choose to include any dependent objects in the DDL comparison. For example, you can include Tables in a database comparison, and triggers in a Table comparison.

When you click Finish, the Compare Editor appears and displays the DDL text of the referenced object and the compare-to object side by side. Use toolbar functions to view the DDL differences and changed elements. You can also edit the text but you cannot move text from one editor window to the other.