From: Simon Slavin <slav...@bigfraud.org>
> I'm curious if there is some standard or normal way to convert a SQLite DB to > a text representation, and then recreate the DB content from the text. > Naively, this seems hard or impossible as a general problem, but perhaps I am > missing something. Yep. It's done a lot, to convert a database to a different SQL engine, or rescue data from a corrupt database. See section 10 of <https://sqlite.org/cli.html#converting_an_entire_database_to_an_ascii_text_file> For more information read the documentation about the '.dump' and '.read' commands on the same page. Or ask here. Simon. Thanks, Simon, for the info. One follow-up: Do you know if the dump output is "deterministic" over time? That is, if I diff two dumps taken at different times, will the unchanged material be in the same order and so on? Or is the ordering effectively random? My underlying question is "can text-comparing two DB dumps be used to determine what has changed?" Thanks again for any insights. Randall Smith _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
