DSXchange

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

You can not do this in a server job.

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

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