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

Options / DataDiff / Set Column Config File

Top  Previous  Next

ss_edit_ccf Here you can specify path to the "column configuration file" used by DataDiff to assign default roles to columns in a new comparison.  You can change the "Filter file" field with the "Choose" ("Browse...") and "Clear" buttons.  The rest of the stuff on this panel is a kind of editor for changing the contents of this file, so what you see there doesn't get saved automatically.

The built-in editor. The options dialog provides a very simple way to edit the column configuration file without using an external editor. Whenever you choose a filename, the file is scanned and all [Ignore], [Compare] and [Keys] rules are displayed in the 3 columns. You can then edit them and save them back to file. Please note that the contents of these three edit boxes are not automatically saved to the file nor cached in memory. Once you close the Options dialog, the file name is remembered, but any changes you might have done to the rules will be lost, unless you have explicitly saved them.

Note that if your configuration file has been created manually and contains repeated sections, or the order of sections is important (like in the example shown above), you must continue using an external editor and should not use the Save button, as it will overwrite your design, writing all the rules into 3 sections in a predefined order.

 

 

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