About Comparing Objects - 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 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.