I need to transfer every day near 200 tables from SQL SERVER to ORACLE incrementally.
For make the process automatically I need to create buffer table by parameter of table name with incremental data from SQL SERVER on ORACLE and then make DELETE-INSERT to the main table.
There is no problem execute SQL statement with SQLExecDirect on SQL SERVER, but how can I get the columns for creating a table on ORACLE with the same structure?
Thanx
Transfer Data Dynamically
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Dont you have any date column in SQL server tables that identifies which rows are incremental?
for the rows that get deleted,, you can perform a periodical refresh of oracle table.
I would really be interested in knowing how those 200 tables can be refreshed in bulk (ie without using the above steps as suggested by me).
for the rows that get deleted,, you can perform a periodical refresh of oracle table.
I would really be interested in knowing how those 200 tables can be refreshed in bulk (ie without using the above steps as suggested by me).