Contents 

AdeptSQL Diff Reference
AdeptSQl Diff versions, history and milestones
Supported versions of MS SQL Server
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Diff in portable mode
Working with the schema
Viewing schema differences
Ignored Differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Generating comparison reports
Customizing the reports
Executing the SQL
SQL errors and warnings
Transaction support
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Comparing table data
DataDiff overview
DataDiff configuration dialog - table-level
DataDiff configuration dialog - columns
Special situations comparing data
Exporting data to Excel
DataDiff Reports
Column configuration file
Configuring AdeptSQL Diff
Options dialog
Schema Scan
Selective Loading
Comparison
Name Comparison
Code Comparison
User-defined types
Indexes and Statistics
Permissions and XProps
Synonyms
Other details to ignore
Scripting
General logic
Side-by-side scripting
Formatting
Identifiers
Schema Level
Tables
Constraints
Default Values
Procedures, Views, etc
Visuals
Text Fonts
Schema Tree
Summary collections
Side-by-Side View
Suppressed dialogs
Data comparison options
General
Scripting
Column Config File
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
License conditions
Contact information

AdeptSQL Diff Online Help

Prev Page Next Page

Side-by-side comparison form

Top  Previous  Next

ss_invoking_compareTo review two versions of a schema object, use the side-by-side comparison panel to the right of the schema view. It opens when you double-click or press Enter on any single schema item. You can also click the "Compare" button on the schema tree's toolbar.

Note that whether two objects are the same or different (and thus need be synchronized) is determined solely by the main schema comparison algorithm and indicated by the color markup in the schema tree.  The side-by-side comparison uses a separate plain-text comparison algorithm and its only purpose is to show you the changes in SQL definitions. There could be situations when the side-by-side view shows differences which are not important and are ignored by the actual schema comparison.  When in doubt, rely on the schema tree.

Also note that the side-by-side view uses its own set of colors, not necessarily synchronized with those used in the schema tree.

ss_sidebyside

Comparison options.  The "Tools/Compare Options" button in the main menu invokes the Options dialog, open on the page where you can specify the appearance of the side-by-side panel.

Weighted phrases. The list of "line weights", which the side-by-side algorithm uses to make certain lines (such as "create proc") to stick to each other, has been moved from the "Compare Options" dialog to an initialization file ASQLDIFF.LWS.  There is normally no reason to change this list, but if you do need to change it, edit it as a regular text file (there are more details inside the file itself).

 

 

   
Converted from CHM to HTML with chm2web Standard 2.85 (unicode)