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 ???

MS has taken great pains to make their stuff work with Oracle. Also, I think you are mistaken about ODBC being "slow." But that said, MS includes a high performance OLE DB driver with their latest products. 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 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 Received on Tue Jan 18 2000 - 16:18:21 CST