Re: Sqlserver 2000 database on Oracle 9 server

Heterogenous Services = Transparent Gateway. TG was the old name. In Oracle 9i, they changed the name to HS. Essentially, they are the same thing. You do not need a seperate license.

HTH,
Brian

Randi W?lner wrote:
>
> 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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"