RE: Querying MS Sql from Oracle

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Mon, 4 Jan 2010 15:05:35 -0500
Message-ID: <SNT130-ds81B72BDC2BEF2A62E5AEEA6740_at_phx.gbl>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kellyn Pedersen
Sent: Monday, January 04, 2010 2:47 PM
To: oracle-l_at_freelists.org; achoto_at_american.edu 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.

http://www.linkedin.com/in/kellynpedersen  

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

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

Received on Mon Jan 04 2010 - 14:05:35 CST