Page History
...
The Data Compare Results window gives users precise information so they have immediate results.
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.
- When 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 "keyspace_name" in ascending order and "Ranges" in descending order, click the "keyspace_name" header and press Ctrl, then double-click "Ranges" header. The icon appearing on the headers are a sign of successful sorting.
...
- By right-clicking the Data Compare table, users get different options to View or Copy.
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. |
- Selecting Copy..., users can select 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. |
Copy with Row Count | Copies the row count, along with the data. |
Copy with Headers and Row Count | Copies column headers and row count, along with data. |
Copy Headers Only | Copies only column headers. |
Copy All with SQL | Copies the row count and column headers, along with the query from which the result set is obtained. |
Copy with Headers (Align Columns) | By default, Results Compare copies data without the column headers. This option copies the headers, along with the data, and align columns. |
Copy with Row Count (Align Columns) | Copies the row count, along with the data, and align columns. |
Copy with Headers and Row Count (Align Columns) | Copies column headers and row counts along with data and aligns columns. |
- Copy As, opens the Copy to Clipboard dialog, giving different options
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. |
Add enclosures per row | |
Include Headers | |
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. |