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