Re: connecting to SQL Server

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 22 Jul 2003 21:38:48 +0100
Message-ID: <3f1da0db$0$15032$cc9e4d1f@news.dial.pipex.com>

"Peter" <depend3_at_yahoo.com> wrote in message news:%JfTa.26861$F92.3153_at_afrodite.telenet-ops.be...
> We would like to make an interface between SQL Server and Oracle 8i(9i)
> where the data comes mainly from SQL Server. What is the best way to do
> this? Any tools available?

There is an Oracle product called transparent gateway. I *believe* this is extra cost. There is a neat MS product called DTS which isn't. There is the programming language of your choice which also isn't chargeable, but may cost.

I'd go DTS.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

Received on Tue Jul 22 2003 - 15:38:48 CDT