Save sqlite :memory: database to disk

[sandy771]

I am contemplating a change to a program whereby a database is initailly created in memory and then later if my users choose they can save it to disk and then switch to using the disk based DB.

I can obviously create a new disk based db, iterate through sqlite_master and then populate each table. But I just wondered whether anyone had any suggestions of a better way of doing this?

[AlexP]

Hello,

There is no such functionality in UniDAC. However, it is implemented in LiteDAC: www.devart.com/litedac/ , in a separate class TLiteBackup.