Navigation:  Data Management > Compare Structures > Tps-Dat to Tps-Dat

Compare Structures of a Tps-Dat Table to another Tps-Dat Table Task

 

Task definition

 

   This task will allow you compare the STRUCTURES of a Tps-Dat Table to another Tps-Dat Table.

 

   [Tps SuperFiles and/or encrypted Tables allowed]

 

 

Step One

 

  Select the PARENT Table with the ellipsis button (navigate to your folder and select)

 

  SuperFiles : if your TPS is of this format you will be offered on another screen to select the table to use

 

  Encrypted Tables : if the password is not already stored in DMC, you will be asked to provide it

 

Step Two

 

  Select the CHILD Table with the ellipsis button (navigate to your folder and select)

 

  SuperFiles : if your TPS is of this format you will be offered on another screen to select the table to use

 

  Encrypted Tables : if the password is not already stored in DMC, you will be asked to provide it

 

Step Three

 

  Click on the "Continue" button to proceed.

 

Trace (Log File) option : will generate a log file for you to have a Step by Step detailed report on the task

 

Close

 

   Cancel this Task

 

---

 

 

Click on the "SendTo" button to generate a REPORT (HTML-PDF-CSV-WORD-EXCEL-XML or Printer)

 

Compare Structures TAB

 

   As you can see in this screen shot ALL differences are displayed visually :

 

   * Select ANY cell will display a "tip" text with the related difference or information

   * TableName cell will display the Structure

   * Differences on Columns or Keys will be displayed with an ICON RED warning : select the cell displayed in BLUE (Parent level) to see more information

   * Array Ranks are displayed (column [D])

   * Differences in the Child "level" are displayed in RED

   * Differences on Columns used within a Key (or their ORDER) is displayed

   * Differences on Primary Keys and DUPE Keys are displayed with ICONS

   * in the ~Keys Node you will find all "unrelated" keys (different names for example - like the "TAGNUMBER_KE")

   * in the ~Columns Node you will find all the "unrelated" columns (different names for example)

   * example (screenshot below) -> the Primary Key ICON is not there in the Child Table

 

 

 

Structure Details TAB (more details)

 

   In this tab you will have access to more conventionaly displayed results :

 

   (selecting the Parent or Child Tables will display the corresponding values)

 

   Columns

 

 

   Keys

 

 

   Structure

 

 

---