I'm now trying to transfer some data from an Oracle database to sqlsever,I
had two questions:

1) There are two providers available( ODBC and OLEDB ) for connecting to
oracle database.which one is better?

2)Are there some guidlines for this specific situation (Transferring between
Oracle and Sqlserver) which gives me a better underestanding of possible
difficulties that I might encouter in the transformation(along with
solutions)

Thanks for your time.

Ali

You will need to install the Oracle Drivers from Oracle first and then I
use the Microsoft OLEDB provider for Oracle


Allan


"ALI-R" <newbie (AT) microsoft (DOT) com> wrote

what I have to install Oracle Drivers from Oracle ? Is there a whitepaper
or some guides available online about Transformation between Oracle and
Sqlserver?

Thanks for yur help
Ali
"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote