re: moving data between backends (fast connectivity need)
- From: Cosmin Ioan <cosmini@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 15 Nov 2007 14:32:58 -0800 (PST)
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
Other related posts:
