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

Settings dialog

This dialog is used to setup application settings:

for Cross-DBMS, 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:
    • Database open/reload group allows you to change the behaviour you've chosen previously using Database reload dialog
    • Oracle section configures the list of system schemas for Oracle databases. It reduces the number of objects read from the database, objects that belong to specified schemas are excluded. Configured as comma-separated list.
  • 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 folder for temporary data diff cache. 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 Cross-DBMS, settings dialog text diff additional lines

  • Misc. 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)
    • Excel reports specifies report file name settings. Application may ask for it every time, or it may auto-generate report file names and put them to some configured folder. In addition, there is an option to auto-open generated reports.

Free version limitations:

  • The whole dialog is not available

Last updated: 2023-10-11