RE: Generic Connectivity

Niall, SQL Server comes with the ability to read and write to Oracle tables practically out of the box. All you need is an Oracle client installed on the SQL Server box. Any changes you make to the source of the data that needs to be transferred to Oracle is probably going to require a change to the process that transfers the data. It would probably get easiest to make these changes at the source.

Only if I needed to pull or push from Oracle would I look as HS. I had set up and tested HS from AIX to SQL Server on NT4 using the Data Direct driver. Development chose to go with Java code instead since it was/is our development direction.

• Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield Sent: Wednesday, June 23, 2004 9:32 AM
To: oracle-l_at_freelists.org
Subject: Re: Generic Connectivity

Thanks for the comments.

On Wed, 23 Jun 2004 05:48:08 -0700 (PDT), Michael Thomas <mhthomas_at_yahoo.com> wrote:

> An alternative might be to use an ETL tool and pump
> major portions of data on a schedule into Oracle.

This was kind of what I had in mind (well scripts and the task scheduler) when I suggested not using sqlservers linked servers feature...

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------