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

Object List Tab

  • Opened from: Home tab
  • Applicable tab-specific toolbar actions:
    • Show all, new and changed, new, changed objects
    • Include new on the left, new on the right, changed, unchanged objects
    • Jump to the last, next, previous, first change
    • Select all, none, invert selection on the left, all, none, invert selection on the right side
    • Refresh information from database. Also updates information about the current object type on the Home tab.
    • Export to Xlsx or Json
    • Generate automation script stub for current object list (with LogTo(), DbOpen(), ObjectsDiff() and commented ObjectsMerge statements relevant for the current databases and project item type)
  • Applicable object types: all

This tab lists all objects of some particular type - tables, views, etc. Allows to identify whether some object is new, changed or unchanged. Note that for tables and views it does not provide information about data/content changes, only about object definitions (like changed column data type for tables or changed select statement for views).

for Cross-DBMS, object list tab

The Name column has a hyperlink that opens text diff tab with object definition. There is one exclusion for the Standard version: 'Table definitions' object type opens table structure diff tab . Object name cell can also contain some additional action buttons depending on object types:

  • opens text diff with a table pseudo-SQL script
  • opens query result diff with select top 1000 rows statement for the given table/view
  • opens data diff for the given table/view
  • opens data diff for the given table/view filtered only to new and changed records

Vertical toolbar between two panels contains additional tab-specific actions:

  • Compare two selected objects
  • Show table DL (foreign key dependency level) toggle makes visible DL column for tables. This value may help to understand the order of tables in the table merge script generated by the application. See Table DL for more information.
  • Show text preview in the bottom

When bottom text preview is active, it contains three more actions:

  • Show tab and space characters (the state of this toggle is synchronized with the same toggle in the Text diff tab)
  • Show line numbers (the state of this toggle is synchronized with the same toggle in the Text diff tab)
  • Word wrap (the state of this toggle is synchronized with the same toggle in the Text diff tab, in rare cases it may disrupt text diff accordance and needs to be disabled, see more)
  • Next change (Alt+PgDown)
  • Previous change (Alt+PgUp)
  • Show text preview line totals
  • Show text preview selected line

Tip: you may notice that among these buttons only Next/Previous change have keyboard shortcuts - that was done to make changes review more convenient using only keyboard. Alt+Down/Up changes selected object and Alt+PgDown/PgUp moves the next/previous change inside the object definition. Similarly, Alt+Shift+Down/Up jumps to the last/first changed object and Alt+Shift+PgDown/PgUp jumps to the last/first change inside the object definition, but these actions have no text preview toolbar buttons, to keep UI more compact and simple.

At the top of the object list it shows changes summary for each side: total count of objects, new, changed and new+changed count. It also shows the number of selected records.

Also the top panel has a small quick filter button that allows to filter object list by name. This can be very convenient for large object lists. This action is also available with Alt+F keyboard shortcut.

At the bottom panel it shows information about selected object - either object name with create/update date/time or text preview. Note that bottom text preview is currently available for all object types except indexes.

See Also


Last updated: 2026-05-06