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

Project tab

  • Opened from: N\A (always shown, default application tab)
  • Applicable tab-specific toolbar actions:
    • Export to Excel
  • Applicable object types: all

This tab shows 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. Once database loaded, this action is replaced with Open another..
  • from path in clipboard: you can copy full path of the database file to clipboard and then open it using this command.
  • with password: opens Open protected files dialog to load password-protected database file to the given side.
  • Open another..: opens the standart file open dialog to choose SQLite database file or *.sqlts file to load to the given side (instead of already loaded one)
  • reload: reload currently loaded database - update its definitions and recompare with other side
  • click on object count: Opens object list tab for the given object type
  • 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 projects 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: open both files
  • open as left/right on the individual file (not pair): open this file to the corresponding Project tab side

Free version limitations:

  • Reduced number of loaded and shown object types: Pragmas are not supported
  • Batch data diff buttons are not available
  • Command from path in clipboard is not available
  • No Excel export
  • 3 items in the Recent projects list

Last updated: 2021-02-09