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 Xlsx or Json Ctrl+Shift+E Generate Xlsx or Json report for the active tab Home tab
Object list
Data diff
Table structure diff
View definition diff
Batch data diff
Query result diff
 Generate automation script stub Opens Script Editor application with draft script for actions related to the current tab. Script will contain logging and database connectivity statements and all supported diff/merge/delete statements related to the content of the current tab. See Scripting for more details. Home tab
Object list
Data 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 Ctrl+F1 Show all rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new and changed Ctrl+F2 Show only new and changed rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only new Ctrl+F3 Show only new rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only chagned Ctrl+F4 Show only changed rows/objects/lines Home tab
Object list
Data diff
Text diff
Batch data diff
Query result diff
 Show only unchagned Ctrl+F5 Show only unchanged rows/objects/lines Home tab
Object list
Data diff
Query result diff
 Last change Alt+Shift+Down Jump to the last block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
View definition diff
 Next change Alt+Down Jump to the next block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) 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 block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) Object list
Data diff
Text diff
Batch data diff
Query result diff
Table structure diff
View definition diff
 First change Alt+Shift+Up Jump to the first block of changes (block is a number of new/changed rows/objects/lines having the same type of changes) 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 rows 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 rows 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 rows 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 rows 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 rows 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 rows 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
 Full screen F11 Switch application to the Full screen mode
 Online help F1 Opens online help page for the current tab
 About license Opens License info dialog

Last updated: 2024-10-21