Re: [sqlite] Memory DB to disk DB

Very good Keith. I think this will work fine for me. thanks Quoting Keith Herold <[EMAIL PROTECTED]>: > I am/was doing this in application, with 2.8.15 . I simply attached > the on-disk database to the memory, and then wrote a bunch of dump > queries to drop the memory data to disk (from the

Re: [sqlite] Memory DB to disk DB

I am/was doing this in application, with 2.8.15 . I simply attached the on-disk database to the memory, and then wrote a bunch of dump queries to drop the memory data to disk (from the memory db connection): ATTACH 'C:\my_database_on_disk.sqlitedb' AS diskdb ; Unfortunately, I don't think you

Re: [sqlite] Memory DB to disk DB

I gues you could attach in-memory db to a newly created disk db and then do something like CREATE TABLE newDiskTbl AS SELECT * FROM memoryTbl Take a look at http://www.sqlite.org/lang_createtable.html for more details Regards, chorlya On Fri, 18 Feb 2005 11:13:40 +1100, [EMAIL PROTECTED]

[sqlite] Memory DB to disk DB

I have a situation where I start with an in-memory DB, then need to save the entire thing to a new disk DB. Does anyone know the best way to do this? Would I attach the memory DB to a newly created disk DB? Is this even possible? I notice the COPY command is not supported in 3.x according to