Data Management Center

SQL COMPARE Table Structures : would any of you like to test this new BETA feature ?

Create an ODBC connection to any SQL(s)
Select Compare Structure task
Select a DB
Select a Table which will be acting as PARENT (others will be compared to this one)
Select a “destination” DB (acting as CHILD tables which will be compared to the PARENT one)
Click on Start task
Select 1 OR MULTIPLE Tables from this “destination” (child) DB
Click on OK and let DMC work

You then get a compared structure screen displayed in a TREE

Icons indicate if a Column or a Key-Constraint is identical or not

Differences are styled in BLEUE to better see them and a TIP is displayed when you HOVER the mouse on those columns

Open a node with a difference and “see” (another style applied) what is different (TYPE-PICTURE-SIZE-PRECISION-DEFAULT-PK-DUPE-BINARY-COLS in a KEY-NULL)

You have a “difference on Constraints-Keys” list at the bottom grouping all Constraints-Keys which are NOT matched by NAME
(these can be a renamed key or an extra one)

Same display for ‘extra’ columns found in CHILD Tables

You can also use Drag&Drop between these “different Constraint-Keys and their PARENT row so as to REPLACE them properly
(this is mainly done for the NEXT step to come ie : synchronization of table Structures)

And finaly you have a SendTo button to EXPORT a REPORT to predefined formats (XLS-HTML-WORD-CSV-PDF or to print etc….)

I would really appreciate any tests and feedback as this IS A NEW feature and many users asked for it and need it

I hope to have done it as easy to use and precise as possible for your everyday work when it comes to comparing tow or several SQL table structures

(it can be used for example to compare a Table in schemaA to any number of tables in any OTHER schema in the same DB or cross platforms on different flavors of SQL)

download link : email me and I’ll send it over

Install and use even in evaluation mode – this beta will let you compare upto 5 tables to a PARENT

Here is a small video (NO SOUND) to show all this
Here is the HTML page produced as resulting report (as not really easy to see in the video)

BTW : I have corrected a BUG when exporting to CSV with TAB as delimiter in the HEADER of the file (I exported a <TAB> instead of a <9> (Merci Bob)

I also added SQL Environment to the MENU AND Navigation bar with a keyboard shortcut of Ctrl+Q
I also added Compare Structures to the MENU AND Navigation bar with a keyboard shortcut of Ctrl+C
I also cganged the physical location of VIEWER TEMP files (holding your columns to Hide/Unhide) from current File Path to a DMC one so as not to clutter your data folders (Merci Abe)

Merci