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

Object list tab

  • Opened from: Project tab
  • Applicable tab-specific toolbar actions:
    • Show all, new and changed, new, changed objects
    • Jump to the next, previous change
    • Select all, none, invert selection on the left, all, none, invert selection on the right side
    • Merge left selected objects to the right side, right selected objects to the left side
    • Replace selected on the right with selected on the left, selected on the left with selected on the right
    • Delete selected objects on the right side, selected objects on the right side
    • Compare two selected objects
    • Export to Excel
    • At the bottom panel show text preview, with totals and/or selected line
  • 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 the most of objects each side has only 3 columns: Name, Created and Modified. In this case Name column has a hyperlink that opens text diff tab with object definition. Object name cell can also contain some additional action buttons for tables and views:

  • opens data diff for the given table/view
  • opens data diff for the given table/view filtered only to new and changed records
  • or or or shows that current table has unchanged, new, changed or both new and changed check constraints. Click on such button opens another object list filtered only for check constraints for this table. shows that table has no check constraints
  • or or or shows that current table has unchanged, new, changed or both new and changed default constraints. Click on such button opens another object list filtered only for default constraints for this table. shows that table has no default constraints
  • or or or shows that current table has unchanged, new, changed or both new and changed indexes. Click on such button opens another object list filtered only for indexes for this table. shows that table has no indexes
  • or or or shows that current table has unchanged, new, changed or both new and changed unique constraints. Click on such button opens another object list filtered only for unique constraints for this table. shows that table has no unique constraints
  • or or or shows that current table has unchanged, new, changed or both new and changed triggers. Click on such button opens another object list filtered only for triggers for this table. shows that table has no triggers

Each object name has selection checkbox nearby - so you can select object with mouse or with Space button from keyboard and do some further actions with selected object - merge, delete, etc. Once you have selected number of rows and clicked merge, replace or delete toolbar button, it will show you the Execute script dialog that will contain SQL script with desired action, so you can review it before apply:

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 number of selected records.

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

Note that Tables and User-defined data types are currently do not support merge, replace and delete actions.

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.

For some object types object list has more columns, it is: table default constraints, check constraints, unique constraints, indexes and foreign keys. For such objects all available information is presented in additional columns and there is no link to text diff for detailed object definition.

Free version limitations:

  • Object name action buttons are available only for Tables and these are only data diff buttons
  • Not available top panel with object counts and quick filter
  • Not available bottom panel with selected object name and date/time or with text preview
  • No Excel export
  • No jump to the next/revious change
  • No changes highlight in scrollbar

Last updated: 2019-07-04