Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> re: moving data between backends (fast connectivity need)
hello everyone,
I'm trying to move data back and forth between MS SQL and Oracle and apparently to do so, **from** MS SQL to Oracle, there's some fast connectors from persistentsys.com
If I try to move data **from** Oracle **to** MSSQL, via a LinkedServer (in MSSQL) using MS OLEDB drivers for Oracle (via inserts), it seems excruciatingly slow (even with columns specified) versus using SSIS via the data flow components (5x slower). Same goes for the Oracle OLEDB drivers for MS and connecting from within Oracle to MSSQL.... pretty slow.
I don't want to get involved with yet another ms tool --if I can help it -- nor introduce a middle tier (SSIS) and was wondering whether anyone has had any experience and can provide any feedback on any fast drivers or setup (again, to move data **from** Oracle **to** MSSQL), be them OLEDB, ODBC, third party connectors or ....Oracle Gateway?? -- did not do any research at all into the latter...
thx much for any feedback,
Cosmin
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Nov 15 2007 - 16:32:58 CST
![]() |
![]() |