Hi All,

We have requirement to transfer data from SQL Server 2000 to Oracle 9i in
AIX machine.
We plan to use DTS to do this.
Have any body tried this ? how to connect to Oracle 9i on AIX, using ODBC ?
Is thrre any known issue here ?

Thanks for your help,
Trist

You'll need to install the Oracle client on the SQLServer
machine. Then use that driver. Shouldn't be a problem.
There are datatype differences between Oracle and
SQLServer that you'll need to be aware of. Check the
books on-line under Oracle.

Hi All

We have requirement to transfer data from Oracle 9i to SQL Server 2000
Have any body tried this

Varsha..

Yep

Use the Oracle drivers for the Oracle connection not the MS Supplied one.

There are also some good articles re moving from Oracle to SQL Server on the
MS Site and the following is one

http://www.microsoft.com/resources/d...rt2/c0761.mspx

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Varsha" <varsha.pandey (AT) lionbridge (DOT) com> wrote

Hi,
Is the fact that the Oracle 9i resides on other platform (UNIX, LINUX) cause
any problems here ?

Thank you,
Trist

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

art2/c0761.mspx

Shouldn't be. So long as you can connect that should be that.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"tristant" <krislioe (AT) cbn (DOT) net.id> wrote