Re: Linked Server to Oracle

Sudhesh,
my company has a product, MetaMatrix, that will link the two in exactly the manner you require. It will also combine the Oracle & MS SQLServer schemas & as a unified virtual database make them both together look like an instance of your MSSQLServer database - then you can get all data together.

Regards

            David Penney
            http://www.metamatrix.com

"Sudhesh Nayak" <Sudhesh_at_mail.com> wrote in message news:8d85e256.0312290944.26fc9878_at_posting.google.com...
> 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 Sun Feb 01 2004 - 20:35:10 CET