This tab allows to compare and merge data for particular table or view (for view only compare). Highlights new and changed records, specific changed fields in the changed row:
Each row has selection checkbox nearby - so you can select number of rows with mouse or with Space button from keyboard and do some further actions with selected rows - merge, delete, export selected only. Column headers for non-key fields also have selection checkboxes - so you can merge only required fields. 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.
Data grid allows sorting on key fields and comparable columns, by mouse click on column name. Note that if you're doing sorting on non-key column - you can get different row count in data grid and different page count, larger than when you had default sorting by key column. This may be confusing from the first look. Here is the explanation by simple example. Let's suppose you have only two columns - ID which is a key and Name, left row has ID=1, Name='A', right: ID=1, Name='B'. With default sorting by key it will be total 1 record, and it will be a changed record because it has the same ID and different Name. But if you do sorting by Name, it has to show Name='A' record followed by Name='B' record. Grid will have to show two records, count and highlight each record on each side as new.
Free version limitations:
Last updated: 2019-07-25