KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Oracle logo for Oracle
 
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
KS DB Merge Tools for Cross-DBMS logo

Text Diff Tab

This tab allows to compare text definition of some particular database programming object (like view or procedure) or text column value:

for Oracle, text diff tab

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

  • Open Data diff for the current table/view
  • Open Data diff for the current table/view filtered only to new and changed records
  • Open Table structure diff tab for the current table, applicable only for tables
  • Open View definition diff tab for the current view, applicable only for views
  • Ignore case
  • Ignore leading and trailing whitespaces
  • Ignore all whitespaces
  • Ignore empty lines
  • Show tab and space characters
  • Show line numbers

The state of Show tab and space characters and Show line number toggles is common for the Text diff tab and other tabs having bottom text preview (Object list, etc.).

Main text area highlights new and changed lines (whole line highlighted), bottom panel shows selected line with per-character changes highlighted. Top panel shows text changes summary: total number of rows, new, changed, new+changed and unchanged line counts. Note that when you change text comparison options like ignore case or white spaces - changes highlight and new/changed totals can be changed because of different text comparison rules.

You can filter text lines to show only new, changed or new+changed lines. In this case most of the unchanged lines are collapsed and can be shown/hidden using the +/- buttons to the left of the text area. Number of unchanged lines shown by default is configured in ADD.LINES field in the right-top corner.

Free Version Limitations

  • Show all/new/changed toolbar actions are not available
  • Not available bottom panel with selected line details
  • No jump to the next/previous change
  • No changes highlight in scrollbar
  • No 'Open data diff', 'Open table structure diff' and 'Open view definition diff' actions
  • No 'Show tab and space characters' action

Last updated: 2025-04-09