Re: Creating DB link with SQL Server

From: Palooka <>
Date: Wed, 15 Apr 2009 15:05:40 +0100
Message-ID: <TQlFl.29618$dr7.18121_at_newsfe16.ams2>

Michael Austin wrote:
> IM wrote:

>> On Apr 15, 9:11 am, yossarian <> 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 ( 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
> I always found it much easier to go from SS->Oracle

Me too. I have used DTS jobs for data mart feeds and the like. They seem to work well.

Palooka Received on Wed Apr 15 2009 - 09:05:40 CDT

Original text of this message