RE: Querying MS Sql from Oracle

  • From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 4 Jan 2010 15:05:35 -0500

I agree with you. We used to use the gateway/odbc/separater listener to get
to sql server and teradata but stopped. Too many hassles. We have sql server
replicating live to our oracle db's. I guess it's pretty easy from the sql
server side. Much easier to let them push to you.



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kellyn Pedersen
Sent: Monday, January 04, 2010 2:47 PM
To: oracle-l@xxxxxxxxxxxxx; achoto@xxxxxxxxxxxx
Subject: Re: Querying MS Sql from Oracle


I may get slammed for this, but as a DBA in both platforms and utilizing
both products in the past, I have to ask-  Is there anyway you can simply
utilize the Microsoft OLE DB Provider for Oracle, adding the Oracle database
server as a linked server on the SQL Server side and query from there?  

I find this to be more stable and require less DBA upkeep....

Kellyn Pedersen

Multi-Platform DBA

I-Behavior Inc.


"Go away before I replace you with a very small and efficient shell


Other related posts: