|
Sql DB to Sql DB |
  
|
|
Sql DB to Sql DB |
|
Compare Structures of an SQL DataBase to another SQL DataBase Task
Task definition
This task will allow you compare the STRUCTURES of an SQL DataBase (multi Tables) to another SQL DataBase.
[Tables are "linked" by NAME - Childless tables are processed but NOT Parentless ones]
Step One
Double-Click on your DataBase to LIST all Tables (pre selected).
If you wish NOT to work on all Tables unselect them.
Step Two
Double-Click on your Child DataBase to work on.
Step Three
Click on the "Start" button to proceed and start the task.
Compare Structures Results of an SQL DataBase to another SQL DataBase 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 "linked" Tables are grouped by PAIRS and 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 (in the above example the IDENTITY is different)
* 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)
* in the ~Columns Node you will find all the "unrelated" columns (different names for example)
* example (screenshot below) -> Childless Tables are displayed as such and Parentless ones only listed.
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
Constraints
Structure
Sql Create Script
