Re: Linked Server to Oracle

I need to go from SQL to Oracle as the Oracle db is owned by a different group within the company... We have more (better) access to the SQL box...

Thanks for the suggestion though
Sudhesh

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1072723371.798845_at_yasure>...
> 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.
Received on Mon Dec 29 2003 - 23:20:03 CET