Re: Creating DB link with SQL Server

From: The Boss <nltaal_at_baasbovenbaas.demon.nl>
Date: Thu, 16 Apr 2009 03:39:32 -0700 (PDT)
Message-ID: <cf137de1-6eb6-41c0-8bcf-75968702c7ac_at_f19g2000yqo.googlegroups.com>



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 Edition)
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 Integration
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

HTH

--
Jeroen
Received on Thu Apr 16 2009 - 05:39:32 CDT

Original text of this message