KS DB Merge Tools
for MS Access
aka AccdbMerge
for SQL Server
aka MssqlMerge
for MySQL
for SQLite
for PostgreSQL
for Oracle
for Cross-DBMS

Text diff tab

  • Opened from: Object list, Data diff and Find tabs
  • Applicable tab-specific toolbar actions:
    • Copy selection to clipboard
    • Show all, new and changed, new, changed lines
    • Jump to the next, previous change
  • Applicable object types: all

This tab allows to compare text definition of some particular database programming object like view or trigger:

for SQLite, 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
  • Ignore case
  • Ignore leading and trailing whitespaces
  • Ignore all whitespaces
  • Ignore empty lines

Main text area highlights new and changed lines (whole line highlighted), bottom panel shows selected line with per-character changes highlight. Top panel shows text changes summary: total number of rows, new, changed and new+changed line counts. Note that when you change text comparison options like ignore case or whitespaces - 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 unchanged lines are collapsed and can be shown using Expand above/Expand below actions in the text. Number of unchanged lines shown by default is configured in the settings dialog, on the 'Text diff' tab, option 'New/changed view additional lines count'.

Free version limitations:

  • Show all/new/changed toolbar actions are not available
  • Not available top panel with changed lines summary
  • Not available bottom panel with selected line details
  • No jump to the next/revious change
  • No changes highlight in scrollbar
  • No 'Open data diff' and 'Open table structure diff' actions

Last updated: 2022-03-11