RE: Generic Connectivity
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 09:54:11 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Niall Litchfield
Sent: Wednesday, June 23, 2004 9:32 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Generic Connectivity
Thanks for the comments.
On Wed, 23 Jun 2004 05:48:08 -0700 (PDT), Michael Thomas
<mhthomas@xxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
