Transfer Data Dynamically

admiral1969 · Post by **admiral1969** » Sun Jun 01, 2008 8:58 am

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

ray.wurlod · Post by **ray.wurlod** » Sun Jun 01, 2008 2:12 pm

You can not do this in a server job.

You could achieve it with routines that employ BCI functions (which mimic ODBC API functions).

Krazykoolrohit · Post by **Krazykoolrohit** » Mon Jun 02, 2008 9:47 am

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).