Navigation:  Data Management > Compare Structures > Sql to Sql

Compare Structures of an SQL Table to SQL Table(s) Task

 

Task definition

 

   This task will allow you compare the STRUCTURES of an SQL Table to one or multiple SQL Table(s).

 

   [inter schema compares are allowed]

 

 

Step One

 

  Double-Click on your DataBase to LIST all Tables available and SELECT the Parent Table to work on.

 

 

Step Two

 

  Double-Click on your Parent Table to work on.

 

 

Step Three

 

  Double-Click on your Child DataBase to work on.

 

 

Step Four

 

  Click on the "Start" button to proceed and select the CHILD table(s).

 

---

 

CHILD Table(s) selection

 

Step One

 

  Double-Click on the CHILD Table(s) to use (you can select MULTIPLE Child tables).

 

   you can compare an SQL Table to Multiple Tables in DIFFERENT schemas (when exists)

 

 

  Be careful NOT to select the Parent Table when working inter-schemas

 

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 an SQL 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 visualy :

 

   * 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

   * 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 ~Constraints 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)

 

   as we are working in this example inter-schemas there is only ONE Node as Object Name

 

   Columns

 

 

   Constraints

 

 

   Structure

 

 

   Sql Create Script

 

 

---