SQLite Diff is a comparison tool for SQLite database files, comparing both the schema and the data. Schema results include comparisons of tables/columns, triggers, indexes and views. Changed SQL code including trigger SQL, index creation SQL, view creation SQL code, and changed data records are displayed as colorized highlighted text to make it easier to see the differences between the compared files. SQLite Diff is implemented as a graphical application allowing developers to easily drag & drop two SQLite databases onto the application to start the comparison process.
SQLite Diff uses a high performance in-memory store of both SQLite schemas to perform most comparisons within in a few seconds. The data comparison feature optionally compares each record within the dropped files using the ROWID as the primary key. SQLite Diff displays schema changes with colorized SQL code and modified records as highlighted text. SQLite Diff is optimized for analyzing undocumented database files.