Re: Linked Server to Oracle

Sudhesh Nayak wrote:

> Hi,
> I have an Oracle (8.1) & a SQL Server 2000 database with
> Production data. There are situations when I need data from both the
> databases. My first choice was to link Oracle to SQL and run DTS
> overnight. But this would have a 1 day latency not to mention the time
> it would take.
>
> 1. Has any one tried real time access via Linked server to Oracle?
> How good is the performance?
>
> 2. The Oracle db is fairly big, so I'm kinda not in favor of
> copying the whole thing over into SQL overnight. Is there an easier
> way to just get only the changed records from Oracle?
>
> 3. Is there a better solution to this?
>
> 4. Lastly, if I use OPENROWSET or OPENQUERY, can I dynamically
> change the SQL that you pass it? e.g. can the query accept a
> parameter?
>
> Thanks in advance
> Sudhesh

Why not use an Oracle database link for real-time access to SQL Server? Also look at Oracle's SQL Server Transparent Gateway for accessing SQL Server with PL/SQL.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)