SQLite Forum

Suggestion for sqldiff
Login
I'm often using columns like "created DEFAULT CURRENT_TIMESTAMP". Now, when importing the same data into two different databases, the result will be identical except for the "created" column. This is a great annoyance when comparing these databases.

It would be a valuable enhancement to sqldiff if it could ignore all "DEFAULT CURRENT_TIMESTAMP" columns in the comparison. One would get a much better impression on whether the data contained are identical or different.