Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

You can open the Compare Objects object chooser via Tools->Compare... and select two objects available for comparison.

Image RemovedImage Added

If you select Editor, all SQL Commander editors and all Object View sub tabs that you have opened that contain text, such as DDL , SQL Editor, and Procedure Editor tabs, are listed. There is also an entry for the System Clipboard, holding the last text you copied.

...

To compare text data, either select both text object from the Tools->Compare dialog or choose Compare from the right-click menu in one of them and select the one to compare to. The text compare window shows you how they differ.

Image RemovedImage Added

The objects are shown side-by-side, with indications about how they differ in the divider between them. The margin areas outside the left and right objects have markings that also show sections of differences. You can navigate between the differences using the arrow buttons in the toolbar, or by clicking the markings to the left and right.

...

Index term
secondarycompare
primarygrid
To compare grids, either select both grid object from the Tools->Compare dialog or choose Compare from the right-click menu in one of them and select the one to compare to. The Compare Grids window shows you how they differ.

Image RemovedImage Added
Comparing grids is a bit complicated, since each row is a unit in itself, with a unique identifier in the form of a Key. A difference can therefore not span rows. It is also important that both grids are sorted the same way and that the column in one grid is compared to the corresponding column in the other grid, otherwise the result is indeterminably. By default, columns are matched by name, or index if the names differ.

If the default matching is not correct, click the Column Configuration button in the toolbar to manually match the columns, and optionally select key columns and ignore some columns.

Image RemovedImage Added
Use the Right Column Name drop down lists to select the column matching the Left Column Name. If a column does not match another, just leave it blank to exclude it from the comparison.

...

It gets a bit more complicated if a key column value is changed.

Image RemovedImage Added

DbVisualizer considers a changed key value as one inserted row and one deleted row, as shown in the figure above. If the grids do not have any declared key columns, all columns are considered to be regular, non-key columns. 

Two grids may also differ in the number of columns they contain. DbVisualizer finds columns that only exist in one of the grids and excludes their values when comparing the grids. If the column names do not match between the two grids, open the Column Configuration dialog to manually map the columns.

Image RemovedImage Added
Similarly, DbVisualizer does not consider Binary/BLOB and CLOB columns when comparing, and marks them as ignored. You can manually specify that CLOB columns should be compared in the Column Configuration dialog.
Image RemovedImage Added
Excerpt Include
Comparing Data
Comparing Data
nopaneltrue

...