Re: Creating DB link with SQL Server
Date: Thu, 16 Apr 2009 03:39:32 -0700 (PDT)
On 16 apr, 00:29, Michael Austin <maus..._at_firstdbasource.com> wrote:
> navneel.si..._at_gmail.com wrote:
> > On Apr 15, 10:09 pm, IM <i..._at_ianmurphy.freeserve.co.uk> wrote:
> >> On Apr 15, 9:11 am, yossarian <yossaria..._at_operamail.com> wrote:
> >>> Mladen Gogala wrote:
> >>>>> Just to add to it, the oracle DB is installed on a linux platform
> >>>> And on which platform is SQL Server installed? Just kidding, we all know
> >>>> that there can be only one, as in Highlander. You can buy a transparent
> >>>> gateway for SQL Server and Oracle will allow you to create a DB link
> >>>> pointing to SQL Server
> >>> You may also want to try a free solution using Oracle Heterogeneous
> >>> Services, UnixODBC and FreeTDS (http://www.freetds.org/) and see if it
> >>> fit your needs.
> >>> Y.
> >> You can also go from SQL Server to Oracle with "Linked Servers" in SQL
> >> Server. May not be what you are after but it's there for you anyway.
> >> Cheers,
> >> IM
> > Is anyone aware of any good online documentation that i can use to
> > connect from SQL Server 2000 to Oracle 10G (residing on a 64 bit linux
> > system). I found few documentation on transparent gateways which
> > allows vice versa connection. Would be gratefull if anyone can point
> > me on how i can connection from SQL Server as well.
> > Thanks.
> did you read any of the previous post where we recommended DTS
> here LET ME GOOGLE THAT FOR YOU...http://lmgtfy.com/?q=SQL+SERVER+DTS+connect+oracle
Your given search will work for environments (like OP's) that still use the relatively old SS2000, but starting with SS2005 Microsoft uses the term SSIS (for SQL Server Integration Services) i.s.o. DTS. Let me therefor copy/paste my answer I gave about a month ago to a very similar question:
Oracle covers this kind of functionality with:
1. Oracle Heterogeneous Services (part of Oracle DB Enterprise
2. Oracle (Transparent) Gateway(s) (separate product license required)
Either search for this on Oracle's website or use Google with f.i.: http://www.google.com/search?hl=en&q=oracle+heterogeneous+services+sql+server http://www.google.com/search?hl=en&q=oracle+gateway+sql+server
Microsoft has similar functionality covered in "SQL Server
Services" (SSIS), so you can Google f.i. with: http://www.google.com/search?hl=en&q=sql+server+integration+services+oracle http://www.google.com/search?hl=en&q=sql+ssis+heterogeneous
-- JeroenReceived on Thu Apr 16 2009 - 05:39:32 CDT