oracle db linked to sqlserver db

[rommel]

Hi friends,

I just read some docs, and i dont know if I understood it well.
It is about linking two databases like oracle db and
sqlserver db. Is it possible to create a table synonym in
an ORACLE database that points to a table in the SQLSERVER
database? The docs seem to imply this way.


Thanks

[KenEwald]

Yes, MS-SQL Server tables can be referenced through a database link using the MSSQL gateway. So you'd create a view, then a synonym for the view. Sounds like a mess to me.

We've found that it's cheaper and more reliable to use a heterogeneous query or DTS package on the SQL Server side though.

Best of luck,

[rommel]

thanks friend,

Can you lead me to some docs on how to set-up
an MSSQL gateway? so our two DBs (oracle-mssql)
can talk with each other.

Thanks again

[KenEwald]

Here's is a good place to start: http://tahiti.oracle.com

Oracle10g - Oracle Database Heterogeneous Connectivity Administrator's Guide
Oracle9i - Heterogeneous Connectivity Administrator's Guide
Oracle8i - Oracle Integration Server Overview

It's a bit of a pain to get setup, but it is definately solid.

This is an expensive route. "Open System Gateways" are $15,000 per server (http://store.oracle.com). Oh, and you'll pay for a database connection on BOTH sides too.

-Ken