Refresh information from database. Current position and page will be reset
Export to Xlsx or Json
Generate automation script stub for data diff (with LogTo(), DbOpen(), DataDiff() and commented DataMerge() statements relevant for the current table; DataMerge() statement can be missing if table can not be merged)
Copy selection to clipboard
all, 
new and changed, 
new, 
changed, 
unchanged rows. Current position and page will be reset
last, 
next, 
previous, 
first change
all, 
none, 
invert selection on the left, 
all, 
none, 
invert selection on the right side
left selected rows to the right side, 
right selected rows to the left side
selected rows on the left side, 
selected rows on the right sideThis tab allows to compare and merge data for a particular table or view (for view only compare). Highlights new and changed rows, specific changed fields in the changed row:
Vertical toolbar between two panels contains additional tab-specific actions:
'Show list of selected columns' shows selected column names under row totals, labeled as SELECTED COLS
'Column mapping' opens Custom data diff dialog to specify key columns, which columns to show and how to map them if you want to compare columns with changed names
or 
'Compare definition' opens table/view definition in table structure diff tab for tables and text diff for views
Ignore case (for the text data)
Ignore leading and trailing whitespaces (for the text data, this option also makes NULL and empty string to be considered as equal)Each row has a selection checkbox nearby - so you can select the number of rows with the mouse or with the Space button from the keyboard and do some further actions with selected rows - merge or delete. Column headers for non-key columns also have selection checkboxes - so you can merge only required columns. Once you have selected number of rows and clicked merge or delete toolbar button, it will show you the Execute script dialog that will contain SQL script with desired action, so you can review it before apply:
Top panel contains:
Bottom panel shows selected line from both sides, providing easier comparison of changed values. Non-key string/text column headers are marked with ◁ triangle character, specifying that click on such column header opens a Text diff tab with this column values pair (can be useful for large or multiline strings).
Data grid key columns are marked with a 🔑 key character. Data grid allows sorting on key columns and comparable columns, by mouse click on column name. Sorted columns are marked with a ▲ black triangle showing the sort direction. Sortable columns are marked with empty triangles.
String data grid values are truncated, large binary values are shown as a number of bytes, according to String and binary display values configuration in the Settings. Large string values can be analyzed separately in the Text diff tab (see above).
