KS DB Merge Tools logo KS DB Merge Tools
KS DB Merge Tools for SQLite logo for SQLite
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo

Settings dialog

This dialog is used to setup application settings:

for SQLite, settings dialog

Each tab has self-descripting options. Here are some more details on the use cases when you may need to change these options:

  • Database Open settings tab:
    • SQLite file extensions configures 'All SQLite DB files' file type filter for the standard database open dialog
    • PRAGMAs group configures PRAGMA loading and has detailed explanation on how it works
    • Database open/reload group allows you to change the behaviour you've chosen previously using Database reload dialog
  • Data diff settings tab configures default behavior for the Data diff tab:
    • Paging specifies default page size
    • String compare options defines the default state of ignore case and ignore leading and trailing whitespaces vertical toolbar action states
    • Local cache specifies a folder to store some temporary data required for data diff and script generation. Note that application cleans up this folder from time to time
  • Text diff settings tab:
    • Text compare options defines the default state of ignore case, ignore leading and trailing whitespaces and ignore all whitespaces toolbar action states for the Text diff tab
    • Text diff tab contains configuration of how many additional lines are shown for new/changed views:

      for SQLite, settings dialog text diff additional lines

  • Appearance settings tab:
    • Application appearance allows to setup some application UI settings:
      • Don't resize toolbar on application zoom allows to keep toolbar unchanged when you zoom application UI using and zoom toolbar actions
      • Max tab header width specifies the maximum width of tab in pixel for the main application tab control
    • Ambiguous object names due to case differences specifies which names should be used for objects with case-insensitive names if there are some changes only in character case. Currently these settings are applied for the Batch data diff tab ('Table name' column) and for the Object list tab (Excel export - 'Name' column)

Free version limitations:

  • The whole dialog is not available

Last updated: 2022-02-17