posted 13 years ago
Hi, are these schemas stored in the same database?
If yes, then it is possible for most databases to create a database user that can access both schemas.
In that case, you can do with one connection. You will gave to put the schema name in front of the table name to make it work.
Example:
insert into ASM.Employee (....
insert into ACD.Manager (....
(note that you are confusing us a bit in your post: the title says: 'multiple schemas', the detail says 'multiple databases'.)
OCUP UML fundamental and ITIL foundation