16.00 - Comparing Database and User Objects in Teradata - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
You can compare the Data Definition Language (DDL) text of two Teradata Database/User objects. You must be able to connect to the Teradata Databases where the objects are stored.
  1. Open the Data Source Explorer and navigate to the Database or User object you want referenced in the comparison. This object is called the referenced object.
  2. Right-click the object and select Teradata > Compare With.
  3. Select a profile from the Select Connection Profile list. The list shows Connection Profiles to which you are currently connected. If you do not see the profile you need, go to the Data Source Explorer and right-click Database Connections to connect to the correct profile.
  4. Use the expanded Database navigation tree to select the Database/User object with which you want to compare. This object is called the compared to object.
  5. Click Next to select additional objects to include in the comparison.
  6. Select additional objects you want to include in the comparison by checking the box beside it. If the database contains no other objects, such as tables or functions, to include in the comparison, the Compare Objects screen is blank.
  7. Click Finish. Results of the object DDL text comparison display in the Compare View.