Page History
...
To launch the Results Compare Tool, first, execute queries, and then in the Aqua Data Studio menu bar, click Tools > Compare Tools > Results Compare. The Select Result Sets dialog displays a list of result sets of the executed queries, out of these, you can select only two for comparison. The Select PK tab in the dialog displays the common column headers present in both the selected result sets. The compare tool can filter the records in the result sets based on the applied primary keys. For more information, see Primary Key.
Comparison Results Scenarios
...
When both result sets contain same columns, then Results Compare shows records of the result set 1 followed by the records of the result set 2. You can scroll vertically to view the complete result. All common column names are displayed and selected by default in the Primary Key tab.
Scenario 2: Result Sets Contain Some Matching Columns
...
You can scroll horizontally to view the comparison result. Columns present in one result set but absent from the other, Results Compare show their cell values as Null. All common column names are displayed and selected by default in the Primary Key tab.
Scenario 3: Result Sets Contain All Different Columns
When both result sets contain all different columns, the Results Compare shows only the first row from both the result set. You can scroll horizontally to view the comparison result. No column names will be displayed in the Primary Key tab.
Comparison Results
The Results Compare shows the comparison result as per the listed scenarios.
The result sets you have selected in the Select Result Sets dialog are displayed together according to their state. This table describes the color code and results for each state.
State | Description |
---|---|
The records exist in result set 1 but not in result set 2. | |
The records exist in both result sets but are different. | |
The records exist in result set 2 but not in result set 1. | |
The records in both result sets are equal. |
You can use the navigation toggle keys ( , ) to navigate between different states and within the same state.
On clicking a cell, view its content in the Preview Panel, also known as the Selected Cell Content area. Contents in the deleted state are displayed in the upper section. Contents in the added state are displayed in the lower section. Contents in the equal and changed states are displayed in both the upper and the lower sections. You can show or hide the Preview Panel by clicking on the toolbar.
You can see the executed query details in the Results Compare for header. You can show/hide this header by clicking on the toolbar. You can also see the total of fetched records and the total time taken to fetch these records right below the Grid tab. You can show/hide this information by right-clicking anywhere in the grid, and then selecting Show/Hide Toolbar.
Results Compare also supports repositioning of columns and multicolumn sorting with ascending and descending. For example, to sort Country in ascending order and Sport in descending order, click the Country header and then press Ctrl, and then double-click Sport header. The icons appearing on the headers are a sign of successful sorting.
Other than this, you can filter comparison result using primary keys or filtering, perform a search operation, and change the display of the grid result using . You can assign new colors to states from the Options dialog. You can refresh the comparison result or perform a new compare. You can save the comparison result in HTML and export it to Excel.
Refresh
Click
If you have executed multiple queries, then you can also choose a different result set via Refresh. In the Select Result Sets dialog, choose a different result set for comparison. Results Compare displays the comparison result in the same Results Compare tab.
You can also perform a new compare when you right-click anywhere in the grid view and choose Results Compare.
...
You can perform these actions in the Results Compare Filter dialog:
State | Action |
Added Rows | Click to show added rows present only in the result set 1. |
Deleted Rows | Click to show deleted rows present only in the result set 2. |
Modified Rows | Click to show modified rows in both result sets. |
Both Equal | Click to show equal rows in both result sets. |
Select all states (), removal (), and inversion () of the last action. |
When you apply a filter, Results Compare shows the Enable filter check box as selected, which means, a filter has been applied. If you unselect this check box, then Results Compare removes the applied filter from the comparison result.
...
The table describes the right-click actions in the grid view.
Right-Click Action | Description |
Select All (CTRL/Command+A) | Selects all records in the grid view. |
Results Compare (CTRL/Command+Shift+K) | Opens the Select Results Sets dialog. |
Copy (CTRL/Command+C) | Copies the selected records in the grid view. |
Copy... | Shows additional options when you point to this option. |
Copy As.. | Opens the Copy to Clipboard dialog. |
Paste to Window | This option is disabled and not applicable to Results Compare. |
View As Text | Displays the selected record in the View dialog. |
Show/Hide Toolbar | Shows/Hides the toolbar in the grid view. |
Copy...
Copy is a right-click option and shows additional options when you point to this option. The following table lists its additional options.
Option | Description |
Copy With Headers | By default, Results Compare copies data without the column headers. This option copies the headers, along with the data. See Attachment. |
Copy with Row Count | Copies the row count, along with the data. See Attachment. |
Copy with Headers and Row Count | Copies column headers and row counts, along with data. See Attachment. |
Copy Headers Only | Copies only column headers. See Attachment. |
Copy All with SQL | Copies the row count and column headers, along with the query from which the result set is obtained. |
Copy As
Copy As is a right-click option and opens the Copy to Clipboard dialog. The following table lists the options in the Copy to Clipboard dialog.
Option | Description |
---|---|
Data Order | Retains the data presentation for horizontal data order. In Vertical data order, displays columns as rows and rows as columns. |
Separator | Adds a separator between 2 cell values. |
Quote Identifier | Adds quotes across cell value. |
Leading Enclosure | Inserts user-specified characters at the start of copied data. |
Trailing Enclosure | Insert user-specified characters at the end of copied data. |
One line per table row | Inserts complete data in one line. |
Wrap Line at Column | Wraps line at a user-specified value and then displays data in the next row. |
Save and Export Comparison Result
...