Re: Sqlserver 2000 database on Oracle 9 server

From: Randi W?lner <randiwolner_at_hotmail.com>
Date: 15 Jan 2004 02:09:28 -0800
Message-ID: <383565c2.0401150209.50bc3199@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1073922683.284194_at_yasure>...
> Hubert Mayr wrote:
>
> > Hi!
> >
> > how could I link a sqlserver 2000 database on a oracle 9 server.
> > or
> > how could I import a sqlserver 2000 database in oracle 9 server.
> >
> > Thanks
> >
>
> Oracle Transparent Gateway.
> Heterogeneous services.
> ASCII files.

I have read some articles about this, but I am a little confused about the difference between "Oracle Transparent Gateway" and "Heterogeneous services".
I want to create a database link so that the application (logging on to Oracle) will not know whether the table is actually stored in Oracle or in SQL Server.

Do I need Oracle Transparent Gateway to make this possible or could that be done only using "generic connectivity"? Do I need a separate license for OTG? The generic connectivty seems to be included with the Oracle software (Enterprise Edition)?

Thanks for help on this,
Randi W Received on Thu Jan 15 2004 - 04:09:28 CST