I noticed that `.dump` does not output the user_version pragma. It seems to me that that is part of the database data?
I don't actually use it, but it might be interesting to add this for completeness? sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; COMMIT; sqlite> pragma user_version=50; sqlite> pragma user_version; 50 sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; COMMIT; _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users