Jay Sprenkle wrote:
Is it possible to copy tables from one memory database to another without going through an intermediate disk database?did you try the really obvious way? create table db2.yourtable(...) insert into db2.yourtable select * from db1.yourtable
For that to work, one first needs to attach one database to the other. ATTACH command requires a file name. Memory database does not have one.
Igor Tandetnik