Re: Dynamic transfer from Oracle to SQL Server

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 1 Aug 2001 18:21:47 +0200
Message-ID: <996682911.7392.0.pluto.d4ee154e@news.demon.nl>

"Kekko" <dinifra_NOSPAM_at_hotmail.com> wrote in message news:3B682325.2021DE6C_at_hotmail.com...
> Hy guys
> is it possible to estabilish a link among an Oracle db and a SQL Server
> one like two Oracle dbs?
> My problem is that my provider has only NT/2000 with IIS and SQL Server
> and my datas are only in Oracle db. I want to public my datas in a
> dynamic way and if it would have an Oracle db I should have done it with
> snapshots or with similar techniques.
> Thanks to everybody.
> Kekko
>
>

It is possible provided
a) you don't crosspost to all Oracle groups b) you get the Oracle Transparent Gateway for Sqlserver. However, I'm not sure whether sqlserver/2000 is yet supported.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Wed Aug 01 2001 - 11:21:47 CDT