neoartz237
Tensai
- Local time
- Yesterday, 20:08
- Joined
- Feb 12, 2007
- Messages
- 65
I have 2 databases, one inbound to access and the other to Oracle.
Now the customer wants me to synchronize the databases by click a button, so I did, it wasnt very difficult anyway.
The approach I used was programmmatically. Like each rows are inserted to the Oracle tables.
It works but time consuming, the whole records ranges to 50-100K. And it takes 4 minutes to import and 5 minutes to export.
Question is, is there an sql schema for this like the good ol'
INSERT INTO tbl1 SELECT * FROM tbl2 thingy?
To be more specific, how can I use the INSERT SELECT in 2 different databases? Oh and using ADO by the way
Now the customer wants me to synchronize the databases by click a button, so I did, it wasnt very difficult anyway.
The approach I used was programmmatically. Like each rows are inserted to the Oracle tables.
It works but time consuming, the whole records ranges to 50-100K. And it takes 4 minutes to import and 5 minutes to export.
Question is, is there an sql schema for this like the good ol'
INSERT INTO tbl1 SELECT * FROM tbl2 thingy?
To be more specific, how can I use the INSERT SELECT in 2 different databases? Oh and using ADO by the way
