Open menu
KS DB Merge Tools logo KS DB Merge Tools
database diff & merge
KS DB Merge Tools for SQLite logo for SQLite
 
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for Oracle logo
AccdbMerge logo
KS DB Merge Tools for Cross-DBMS logo
KS DB Merge Tools All-In-One license
Other tools

Compare View Results

In this use case, we compare the result sets of a view between two SQLite databases. You’ll see new and changed rows, identify differences by key columns, and review field-level changes. This feature is available only in the Standard version.

  1. Open databases (see the Schema Changes Summary use case) and A click Views.

    for SQLite, Home tab click Views
  2. In the opened Object list, click B Compare data for the required view. Then C specify the key columns combination and D click OK

    for SQLite, Object list tab click Compare data
  3. The Data diff tab opens with view comparison results. A row present in both databases with different values is counted as changed (highlighted in red). A row missing in the target is counted as new (green). Use filter E to show only new or only changed rows. The header shows F total counts, and the footer shows G column-level differences for the selected row. For large text values, click the column name in the footer H to open a separate Text diff tab with the value comparison.

    for SQLite, Data diff for views