KS DB Merge Tools logo KS DB Merge Tools
Documentation
MssqlMerge logo for SQL Server
aka MssqlMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

Toolbar actions

Toolbar has buttons for the most common application actions. Some of these actions have keyboard shortcuts. Some actions can be disabled at some moment of time: this action can be non-applicable for the current tab or for the current application state. Usually the action disable reason is shown in the toolbar button tooltip.

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
 Find Ctrl+F Open Find tab
 Refresh Ctrl+Shift+R Refresh information from database for the active tab Home tab
Object list
Data diff
 Export to Excel Ctrl+Shift+E Open Excel report for the active tab Home tab
Object list
Data diff
Table structure diff
View definition diff
Batch data diff
Query result diff
 Copy selection to clipboard Ctrl+C Copy selected data grid cells or text lines to clipboard. Use Shift key to select multiple cells/rows Home tab
Object list
Data diff
Text diff
Query result diff
 Show all records Ctrl+F1 Show all records in the primary data grid of the current tab Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new and changed records Ctrl+F2 Show only new and changed records in the primary data grid of the current tab Home tab
Object list
Data diff
Text 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 Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only changed records Ctrl+F4 Show only changed records in the primary data grid of the current tab Home tab
Object list
Data diff
Text 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
Table structure diff
View definition diff
 Previous change Alt+Up Jump to the previous new/changed row/record Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
View definition 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
Table structure diff
View definition 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
Table structure diff
View definition 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
Table structure diff
View definition diff
 Merge to right Ctrl+M Merge to the right selected records from the left Object list
Data diff
Table structure diff
View definition diff
Batch data diff
 Delete selected on the left Ctrl+D Delete selected item(s) on the left side Object list
Data diff
Table structure diff
View definition diff
Batch 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
Table structure diff
View definition 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
Table structure diff
View definition 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
Table structure diff
View definition diff
 Merge to left Ctrl+Shift+M Merge to the left selected records from the right Object list
Data diff
Table structure diff
View definition diff
Batch data diff
 Delete selected on the right Ctrl+Shift+D Delete selected item(s) on the right side Object list
Data diff
Table structure diff
View definition diff
Batch 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
 Online help F1 Opens online help page for the current tab
 About license Opens License info dialog

Last updated: 2023-10-11