AdeptSQL Diff - screenshot explained

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.

See details...

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.

See details...

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.

See details...

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.

See details...