KS DB Merge Tools
Documentation
for Microsoft Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
 
for SQLite
 

Toolbar actions

Most common actions are always shown in toolbar, however they can be disabled if this action is not applicable in the current situation. For example, Find toolbar is disabled until you open any database.

Some other actions are more specific to some concrete tabs and hidden at all for other tabs. For example, Compare selected is shown only for the Object list tab.

Action                            Keyboard shortcut Description Applicability           
 Open database(s) Ctrl+O Opens Open databases dialog
 Open *.msdbs file(s) Ctrl+Shift+O Opens standart file open dialog to choose *.msdbs file(s)
 Batch data diff Ctrl+Shift+B Opens Batch data diff tab
 Query result diff Ctrl+Shift+Q Opens Query result diff tab
 Custom data diff Ctrl+Shift+C Opens Custom data diff dialog
 Export to Excel Ctrl+Shift+E Open Excel report for the active tab Object list
Data diff
Batch data diff
Query result diff
 Find Ctrl+F Open Find tab
 Show all records Ctrl+F1 Show all records in the primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Show only new and chagned records Ctrl+F2 Show only new and chagned records in the primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Show only new records Ctrl+F3 Show only new records in the primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Show only chagned records Ctrl+F4 Show only chagned records in the primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Next change Alt+Down Jump to the next new/changed row/record Object list
Data diff
Text diff
Batch data diff
Query result diff
 Previous change Alt+Up Jump to the prevous new/changed row/record Object list
Data diff
Text diff
Batch data diff
Query result diff
 Select all on the left Select all records in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Select none on the left Unselect all records in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Invert left selection Ctrl+A in the active grid Invert selection in the left primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Merge to right Ctrl+M Merge to the right selected records from the left Object list
Data diff
 Replace to right Ctrl+R Replace selected item on the right with selected item on the left. Only one item must be selected on each side Object list
 Delete selected on the left Ctrl+D Delete selected item(s) on the left side Object list
Data diff
 Select all on the right Select all records in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Select none on the right Unselect all records in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Invert right selection Ctrl+A in the active grid Invert selection in the right primary data grid of the current tab Object list
Data diff
Batch data diff
Query result diff
 Merge to left Ctrl+Shift+M Merge to the left selected records from the right Object list
Data diff
 Replace to left Ctrl+Shift+R Replace selected item on the left with selected item on the right. Only one item must be selected on each side Object list
 Delete selected on the right Ctrl+Shift+D Delete selected item(s) on the right side Object list
Data diff
 Settings Opens Settings dialog
 Zoom out application Ctrl+Minus Zoom out application UI, decrease scale of all UI elements
 Zoom in application Ctrl+Plus Zoom in application UI, increase scale of all UI elements
 About license Opens License info dialog
 Compare selected Opens Text diff tab to compare two selected items. Only two items must be selected to make it work, both can be from the same left/right side Object list
 Show text preview Show bottom text preview palel Object list
 Show text preview totals Show line totals panel in the bottom text preview palel Object list
 Show text preview selected line Show selected line panel in the bottom text preview palel Object list
 Ignore case 'Ignore case' text comparison option for object text and string columns Text diff
Data diff
Query result diff
 Trim leading and trailing whitespaces 'Ignore leading and trailing whitespaces' text comparison option for object text and string columns. For Data diff and Query result diff it also forces NULL values to be considered the same as empty string. Works per line, it does not exclude all empty lines from text - if one side has blank/whitespace line and other side has no line at all, this still be considered as new line Text diff
Data diff
Query result diff
 Ignore all whitespaces 'Ignore all whitespaces' text comparison option for object text and string columns. Works per line, it does not exclude all empty lines from text - if one side has blank/whitespace line and other side has no line at all, this still be considered as new line Text diff
Data diff
Query result diff

Last updated: 2019-07-25