I agree with Simon, there is no direct way to export your data as SQL commands. But there are a few things you can do;
1> Code it out yourself, but you'll need to be aware of how you're dealing with the order you need 2> As you're making changes to the database, write out the inserts/updates/deletes into another file, or, put them into another :memory: table and export as needed 3> Use the backup API and skip the whole management of SQL commands as certain characters just make you pull out your hair. Unless you're bald. Which would make pulling out your hair difficult. .. I'd presume... On Thu, May 29, 2014 at 5:59 AM, big stone <[email protected]> wrote: > Hello, > > I would like to save my sqlite ':memory:' database into a sql command text > file. > > With sqlite.dll, what is the procedure/algorithm ? > Is it already explained somewhere on Internet ? > > > At first look, I may imagine that I need to : > - create tables in a certain order (keeping the comments for documentation > purpose) > - then insert datas, > - then create views and index, in another certain order > - then create stored procedures at the end, to avoid changing datas during > the re-feeding of tables > > Regards, > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
