Re: Creating DB link with SQL Server
From: Palooka <nobody_at_nowhere.com>
Date: Wed, 15 Apr 2009 15:05:40 +0100
Message-ID: <TQlFl.29618$dr7.18121_at_newsfe16.ams2>
Michael Austin 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
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 <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
> > > 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