Set Comparison Options

DBA xPress ›› Features ›› Data Inspector ›› Comparison Phases ››
Parent Previous Next

Set Comparison Options


Once the data sources have been loaded, the comparison options screen is shown 

 

There are two categories of object shown here: ones for which a match can be found, and ones for which a match was not found. Within the objects for which a match was found, there are fully matched objects (green icon) and partially matched objects (yellow icon). Fully matched means that all columns were matched, and partially matched means that some columns were missing from one of the two sides.

 

To change the mappings for the columns, we can double click on a particular comparison, or click on it and then click the 'Map Columns' button. This also enables us to set a data filter for the source and target objects, and to change the source and target objects entirely. For more information, see the edit mappings topic.

 

The filter button is split into two parts. Clicking on the left hand part will bring up the filter dialog, discussed below. Clicking on the right hand part will control whether filtered items are hidden (the default) or whether they are shown. If they are shown, filtered items appear in gray. A category which only contains filtered items will also show in gray.

 

Clicking on the settings button brings up the comparison settings dialog, where comparison and generation options, as well as the comparison name, can be changed.

 

Filtering

Clicking on the filter button brings up the filters dialog:

 

 

Here, we can change the mode in which filters apply, and add, edit and remove filters. The filtering system is exactly the same as is used for object browser filtering, with one minor difference: that the overall filter mode applies to the complete list of filters, rather than each individual one. Therefore, the overall filter mode drop down box is not shown when editing filters for use with a comparison scenario. Having added filters to match only objects where the name starts with 'tblCfgTest', and set the mode to 'Include only matching objects' we return to the main display:

 

 

Notice that the filter icon is now gold, to signify active filters. Clicking on the right hand part of the filter button, and selecting 'Show filtered items' changes the display to the following:

 

 

Categories which contain only filtered items are grayed, and they also say '0 selected' - showing that all items in those categories have been deselected. Categories with some items filtered are semi-grayed, and report the selected number of objects normally. You can, if you wish, expand the items and select filtered items as you would normally.

 

Filters are saved with the comparison scenario, and will automatically be re-applied next time the comparison opens. Therefore, if there are specific objects that you wish to ignore every time the comparison is run, it is beneficial to set up a filter to automatically de-select those objects.

 

After clicking on compare, the data comparison process will begin.