Your database comparison
and synchronization tool
Diff tool:Introduction  Screenshots  Order now  Revision history  Documentation  
Adept SQL Tools
Diff tool  
Downloads
Ordering
Quotes
FAQ
Contact us

AdeptSQL Diff - screenshot explained

The schema treeSQL Code ViewerSQL Code ViewerSide-by-side comparison view  

How to use this page:
  • Point the cursor at any part of the snapshot to see the explanation.
  • Click on the picture to see the relevant chapter from AdeptSQL Diff's online documentation.

Once you specify the two databases to compare, schema information is extracted from each of them, compared and displayed in this tree view.

The tree contains schema items from both databases, with any differences highlighted. When you double-click on any item, the program shows their SQL definitions, compared side-by-side.

Click on the picture to find more!

This script was generated by the program to synchronize the differences between the two databases. It can be created for a single schema object, several selected objects or the entire schema.

You do the synchronization in any direction - this window shows the script to be applied to the first of the compared databases in order to synch it with the second one.

Click on the picture to find more!

This script was generated by the program to synchronize the differences between the two databases. It can be created for a single schema object, several selected objects or the entire schema.

You do the synchronization in any direction - this window shows the script to be applied to the second of the compared databases in order to synch it with the first one.

Click on the picture to find more!

This side-by-side comparison window works on a single schema item. It compares the two SQL definitions taken from each of the databases being compared. All differences are color-marked.

In this example, the only difference is that one of the table columns is declared as NOT null in the scripts but it's nullable in the live database. The popup window above shows the script generated to eliminate this difference.

Click on the picture to find more!


Copyright © Adept SQL Tools, 2002-2011