← Back to context

Comment by wmanley

3 years ago

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.