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

Home tab

  • Opened from: N\A (always shown, default application tab)
  • Applicable tab-specific toolbar actions:
    • Refresh object definitions and diff results
    • Export to Excel
    • Copy selection to clipboard
    • Show all, new and changed, new, changed objects
  • Applicable object types: all

That's the initial application tab. It is used to open databases and summary about all database objects. Note that it does not provide information about data/content changes, only about object definitions.

Tab is splinted in two parts, each of them represents database being compared. Each part shows path of the loaded database and allows the following actions:

  • Open database - opens the standart file open dialog to choose SQLite database file or *.sqlts file for the given side
  • Open database from path in clipboard - you can copy full path of the database file to clipboard and then open it using this command
  • Open database with password - opens Open protected files dialog to load password-protected database file to the given side
  • Refresh - reload currently loaded database - update its definitions and recompare with other side
  • Show in folder - opens windows exlorer with folder containing database file
  • click on object type name: Opens object list tab for the given object type (all objects)
  • click on object count: Opens object list tab for the given object type filtered to objects representing this count
  • small batch data diff buttons : for tables and views you can open batch data diff tab filtered for tables or views respectively

Note that Pragmas are marked with 'DIFF ONLY' because they are only compared and can't be synchronized. Tables are marked with 'MERGE NEW ONLY' because application currently does not support changes syncronization for existing tables (like import just one new column for existing table). You can import only new table definition. For existing tables you can drop target table and then import source table as new, however in this case 1) you'll loose data in the target table, and 2) drop action may fail because of other objects depending on that table.

At the bottom there is a collapsible Recent databases section showing last file pairs that were opened. Note that if you're running multiple application instances in parallel then one application can overwrite recent files data saved by another application instance. Maximum number of recent pairs is 10 for Pro and 3 for Free. Each file pair has the following actions:

  • Open both databases
  • Open this database in the left panel
  • Open this database in the right panel

Free version limitations:

  • Reduced number of loaded and shown object types: Pragmas are not supported
  • Batch data diff buttons are not available
  • Command 'Open database from path in clipboard' is not available
  • Command 'Open database with password' is not available
  • Command 'Show in folder' is not available
  • No Excel export
  • No Copy to clipboard
  • 3 items in the Recent databases list

Last updated: 2022-02-17