Re: Oracle Gateway to SqlServer
- From: Paul Baumgartel <paul.baumgartel@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 9 May 2005 09:48:29 -0400
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@xxxxxxxxx
On 5/9/05, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
