Re: Ms link to Oracle - best solution

Aleksander Miler wrote:
>
> Hi,
>
> Does anybody knows what can be the best solution for importing data from
> Oracle database to Microsoft tools. I mean especially about MS Sql Server
> and its OLAP tools.
> One of solutions can be ODBC - unfortunatelly as I know it is not very fast
> :-(
> Maybe anybody knows (and has some experience) something else - maybe about
> ADO or OleDB (esp. concerning Oracle) ?? Or maybe the best selution would be
> to use Oracle OCI interface ???

[Quoted] MS has taken great pains to make their stuff work with Oracle. Also, I [Quoted] think you are mistaken about ODBC being "slow." But that said, MS includes a high performance OLE DB driver with their latest products. [Quoted] But you should also be able to use the Oracle ODBC driver. Another alternative is just to export the data into a text file, then use bcp to [Quoted] load it into MS SQL.

--
Brad Aisa <baisa_at_NOSPAMbrad-aisa.com>
http://www.brad-aisa.com/   -- PGP public key available at:
http://pgp.mit.edu:11371/pks/lookup?search=Brad+Aisa&op=index

"The paper wall will be next to fall." -- Brad Aisa