sqldiff.exe: Database Difference Utility
The sqldiff.exe binary is a command-line utility program that
displays content differences between SQLite databases. Example
usage:
sqldiff [options] database1.sqlite database2.sqlite
The usual output is an SQL script that will transform
database1.sqlite (the “source” database) into database2.sqlite
(the “destination” database). This behavior can be
altered using command-line switches:
- –changeset FILE
-
Do not write changes to standard output. Instead, write a (binary)
changeset file into FILE. The changeset can be interpreted using
the session extension to SQLite. - –lib LIBRARY
- -L LIBRARY
-
Load the shared library or DLL file LIBRARY into SQLite prior to
computing the differences. This can be used to add application-defined
collating sequences that are required by the schema. - –primarykey
-
Use the schema-defined PRIMARY KEY instead of the rowid to
pair rows in the source and destination database. (See additional
explanation below.) - –schema
-
Show only column name and table differences in the schema,
not the table content - –summary
-
Show how many rows have changed on each table, but do not show
the actual changes - –table TABLE
-
Show only the differences in content for TABLE, not for the
entire database - –transaction
-
Wrap SQL output in a single large transaction
- –vtab
-
Add support for handling FTS3, FTS5 and rtree virtual tables.
See below for details.
The sqldiff.exe utili