Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> re: moving data between backends (fast connectivity need)

re: moving data between backends (fast connectivity need)

From: Cosmin Ioan <cosmini_at_bridge-tech.com>
Date: Thu, 15 Nov 2007 14:32:58 -0800 (PST)
Message-ID: <236841.6999.qm@web60412.mail.yahoo.com>


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-l
Received on Thu Nov 15 2007 - 16:32:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US