Re: Linked Server to Oracle

One thing you have to watch out for, I don't think Oracle 8.1 supports the SQL-92 join syntax, IOW you have to do the joins in the where clause.

Another developer at my company is using DTS and I am not impressed with the results. I prefer to code whatever ETL I want to do myself, that way I have a lot more control and much better oversight... when you use DTS if you want to see what it's doing you have to open up the packages and click on all the little icons etc, and I don't think there's any way to step through to debug either.

On 29 Dec 2003 09:44:22 -0800, Sudhesh_at_mail.com (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
Received on Tue Dec 30 2003 - 07:34:29 CET