Moritz Angermann wrote: > with the online backup capabilities, I was wondering if anyone > hand ome insight into performing an online restore, e.g. restore > data from a backup into an active instance.
<http://www.sqlite.org/backup.html> says: | The online backup API allows the contents of one database to be copied | into another database, overwriting the original contents of the target | database. There is not much of a difference between backup and restore. The bottom of <http://www.sqlite.org/c3ref/backup_finish.html> has some scary words about concurrency: | the application must guarantee that the destination database | connection is not passed to any other API (by any thread) after | sqlite3_backup_init() is called and before the corresponding call to | sqlite3_backup_finish(). However, this applies only to the connection object itself, not to the database. Both source and destination databases are correctly locked within transactions, and can be open in other connections. Regards, Clemens
