Re: How to Replicate from SQL Server 2000 to Oracle 9i

Hi Piter,

Yes, you are right about the OpenLink Multi-tier ODBC driver not supporting Oracle 9i but you can download the Multi-tier driver for Oracle 8i and you should be able to connect to your Oracle 9i database using this driver. Certainly, I have done this successfully.

Another option is that if you have the Oracle 9i client for Windows installed on the SQL Server machine then you can evaluate the OpenLink Single-tier (Lite) ODBC driver for Oracle 9i which are available and connect to your database.

I hope this helps,

Ashok Rautela

piter197 <member21811_at_dbforums.com> wrote in message news:<2370436.1042169734_at_dbforums.com>...
> Originally posted by Ashok Rautela
> > Hi Piter,
> >
> > I think that you need to look at a couple of issues:
> >
> > 1) Connectivity between the SQL Server 2000 database and Oracle 9i
> > 2) Data Replication from SQL Server 2000 database to Oracle 9i
> > database at the scheduled time
> >
> > Regarding the 1st issue you can look at ODBC connectivity between SQL
> > Server and Oracle 9i i.e. ODBC drivers. I have successfully made
> > connection between SQL Server 2000 and Oracle database using the
> > OpenLink ODBC drivers:
> >
> > http://www.openlinksw.com/http://www.openlinksw.com
> >
> >
> > Hi Ashok,
> >
> > I've looked the link you suggested, they don't have the driver for
> > Oracle 9i yet. Do you ever use it with Oracle 9i before? is it
> > running well?
> >
> > BTW, thanks for your information.
> >
> > Once the DSN connection is established you can either use the SQL
> > Server DTS (Import/Export data) tool to create a package that will run
> > automatically (with this DSN) to create and replicate data from SQL
> > Server into Oracle. The other alternative is to use the Oracle 9i
> > Heterogeneous Services and 'pull' the data from SQL Server. I must
> > admit that I haven't tried the Oracle Hetergeneous Services to do this
> > though. Regarding the Read only Replication, you can specify this
> > during your package creation.
> >
> > I hope this helps,
> >
> > Regards,
> >
> > Ashok Rautela
> >
> >
> >
> > piter197 wrote in message news:news:...
> > > Hi,
> > >
> > > Is there any way/tool to make a copy/read only replication from
> SQL
> > > Server 2000 to Oracle 9i running on Solaris?
> > >
> > TIA
Received on Fri Jan 10 2003 - 15:51:53 CET