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
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.
It's not :memory:?
From the docs:
http://sqlite.org/lang_attach.html
Syntax of the command:
ATTACH DATABASE
sql-statement ::= ATTACH [DATABASE]
Igor Tandetnik wrote:
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.
Randy Graham [EMAIL PROTECTED] wrote:
Is it possible to copy tables from one memory database to another
without going through an intermediate disk database?
Can't you just write a function that would run select * from table on
one db, and for each record build and execute an insert statement
Igor Tandetnik wrote:
Randy Graham [EMAIL PROTECTED] wrote:
Is it possible to copy tables from one memory database to another
without going through an intermediate disk database?
Can't you just write a function that would run select * from table
on one db, and for each record build and
Hello, I was thinking about a trick that I once used with an Oracle database.
To speed up a data transfer from one database to another, I put the redo log
files on a RAM disk. I was severely flamed for this unresponsible suggestion
but it made things quicker. Later I learned that there exists