Comment by simonw
3 years ago
SQLite actually ships a little-known utility called sqldiff that implements a subset of this idea: https://www.sqlite.org/sqldiff.html
It's more focused on content diffs than schema diffs though.
3 years ago
SQLite actually ships a little-known utility called sqldiff that implements a subset of this idea: https://www.sqlite.org/sqldiff.html
It's more focused on content diffs than schema diffs though.
Wow, I hadn't come across that before. It's so close to being what we want, but not quite right. They've even considered this specific use case:
> 3. The sqldiff utility is not designed to support schema migrations and is forgiving with respect to differing column definitions. Normally, only the column names and their order are compared for like-named tables before content comparison proceeds. > > However, the single-table comparison option, with "sqlite_schema" named, can be used to show or detect detailed schema differences between a pair of databases. When doing this, the output should not be used directly to modify a database.