It should be easy to write your own dump feature. The table create statements are saved in sqlite_master, and likewise for the schema. Without looking at the code for sqlite3 (the command line utility) or tksqlite, I would bet that is how they implement their dump feature.
On Mon, Mar 3, 2008 at 11:53 AM, Dennis Cote <[EMAIL PROTECTED]> wrote: > Abshagen, Martin RD-AS2 wrote: > > Can a backup mechanism be implemented by means of the current Sqlite-API? > > Well, no, but the database is a single file, so you can back it up by > copying the file. > > If you are concerned about other processes accessing the database while > you are copying it, have your program start an exclusive transaction > before the copy,and roll it back after the copy. > > HTH > Dennis Cote > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users