Re: Oracle Gateway to SqlServer

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Mon, 9 May 2005 09:48:29 -0400
Message-ID: <f8c477105050906485f2f03df@mail.gmail.com>

Tom,

Yes, I've used the Gateway and it worked reliably well. The only thing I can think to mention offhand is that, since many SQL Server object names are in lower or mixed case, you have to remember to double-quote them when accessing from Oracle (e.g., select * from "employees"@gateway_link).

--=20
Paul Baumgartel
paul.baumgartel_at_gmail.com

On 5/9/05, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> All,

>=20

> We have a new requirement where an Oracle database application will need
> recurring data from a SqlServer database. By recurring data I mean that
> every day, there will be new data placed into a sqlserver database, and
> that this data will need to be available from the Oracle database.

>=20

> Has anyone used the Oracle Gateway to SqlServer product? Does it work
> well? Is this a better option than an export, sql Loader, and PL/SQL
> process option? Any obvious problems using this product?

>=20

> Thanks

>=20
> Tom

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 09 2005 - 09:52:58 CDT