|
Tps-Dat to SQL |
  
|
|
Tps-Dat to SQL |
|
Compare Structures of a Tps-Dat Table to SQL Table(s) Task
Task definition
This task will allow you compare the STRUCTURES of a Tps-Dat Table to one or multiple SQL Table(s).
[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
Click on the "Continue" button to proceed and select the CHILD Table(s)
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
CHILD Table(s) selection
Step One
Double-Click on the SQL DataBase to use.
Screen is changed to allow you to proceed with the next Step.
Step Two
Click on the "Start" button to proceed and select the CHILD Table(s) to use.
Step One
Double-Click on the CHILD Table(s) to use (you can select MULTIPLE Child tables).
you can compare a Tps-Dat Table to Multiple Tables in DIFFERENT schemas (when exists)
Cancel
If you do NOT select a Table then clicking on the "Continue" button will take you BACK one Step to start again and change the CHILD SQL DataBase
Step Two
Click on the "Continue" button to start the Task.
Compare Structures Results of a Tps-Dat Table to SQL Table(s) 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
* Table cell will display the SQL SCRIPT to CREATE the table
* 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 (Parent) 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 "dmc_TAGNUMBER_KEY")
* in the ~Columns Node you will find all the "unrelated" columns (different names for example)
* example (screenshot below) -> the ORDER of the columns used in TagNumber_Key is different
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
Sql Create Script
