Home -> Usenet -> comp.databases.oracle -> Linked Server to Oracle

Linked Server to Oracle

From: Sudhesh Nayak <Sudhesh_at_mail.com>
Date: 29 Dec 2003 09:44:22 -0800
Message-ID: <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 Mon Dec 29 2003 - 18:44:22 CET












Original text of this message