Make several large DBs as your input in that case and do -
select from DB1
select from DB2
...
select from DBn
insert into output
Serena Lien wrote:
No, I am not copying anything to an in-memory database, this was just an
alternative option I was suggesting, so please ignore the whole in-memory
database thing from now on..
I have more databases to attach than the maximum number allowed, so no, I
cannot attach my input databases to make one large DB.
I believe my only option is to attach databases one at a time, and use
multiple transactions around the attach/detach commands, since I cannot
attach databases within a transaction.
Serena.
>
Why7 copy to an im memory database? Why not just create a regular
database as your output. The is no reason you cannot have more than one
DB connection current in any process or thread.
How about -
Attach your input databases to make one large DB
select your output data
insert output data into the output DB
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
