Re: Pulling data into Oracle from SQL Server
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: Lee.Robertson@xxxxxxxxxx
- Date: Thu, 27 Oct 2011 13:49:21 +0200
There's DG4ODBC, the free ODBC gateway from Oracle to xxx.
On Thu, Oct 27, 2011 at 1:46 PM, Robertson Lee - lerobe <
Lee.Robertson@xxxxxxxxxx> wrote:
> Hi,
>
> Was wondering if anyone had experience of the best (and cheapest) way
> to do this was ?
>
> On Linux with Oracle 11gR2. SQL Server is 2008 I think (maybe 2005)
>
> I know we can do it from the other side i.e push the data in from SQL
> Server but it would be preferable to have this is as part of our
> existing process so could be ran from within an Oracle package.
>
> i.e does some stuff in a proc then starts sucking some data from the SQL
> Server DB.
>
> I was hoping to avoid any expensive "Gateway" products ?
>
> Cheers and TIA
>
> Lee
> ***************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be legally
> privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank You.
>
> ****************************************************************************
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Toon Koppelaars
RuleGen BV
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com
TheHelsinkiDeclaration.blogspot.com
(co)Author: "Applied Mathematics for Database Professionals"
www.rulegen.com/am4dp-backcover-text
--
//www.freelists.org/webpage/oracle-l
Other related posts:
