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
