Not that I'm favoring M$ tools too much but I heard that DTS is pretty
simple and fast. At least on our clients is using it to pull data from
Oracle and they don't complain.
I think they use Oracle ODBC driver.
On 11/15/07, Cosmin Ioan <cosmini_at_bridge-tech.com> wrote:
> 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
>
>
>
--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 15 2007 - 17:35:49 CST
