On 10 Jul 2018, at 1:52am, Randall Smith <rsm...@qti.qualcomm.com> wrote:
> 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. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users