Contents 

AdeptSQL Diff Reference
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Working with the schema
Viewing schema differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Configuring schema options
Comparing table data
DataDiff overview
Data comparison options
Column configuration file
Special situations comparing data
Executing the SQL
SQL errors and warnings
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
Contact information
Version history (last updated for ver. 1.90 [Build 58])

AdeptSQL Diff Online Help

Prev Page Next Page

Understanding Schema Differences

AdeptSQL Diff displays schema information from both databases in the same tree view, which may be a bit unusual at the beginning. The program uses color highlighting to indicate any changes in the schema. Here is how you should read an example snapshot:

Left-hand DB

Right-hand DB

What it means

Authors

Authors

These tables differ

BookStock BookStock These are identical on both sides
(not present) BookTitle In the second database only
BookTitleEx (not present) In the first database only

All colors and font styles for the highlighting are configurable, you can change them in the Schema Options dialog.

The highlighting hint window

When you first start the program, you will see a help window explaining the color coding. Once you familiarize yourself with the colors, you'll most likely want to check the "Don't show again" option and get rid of this window.

 

   
The CHM file was converted to HTML by chm2web software.