RE: data from sql server to oracle on linux

From: William B Ferguson <wbfergus_at_usgs.gov>
Date: Thu, 26 Jan 2006 08:22:06 -0700
Message-ID: <OF64040B40.2668538F-ON07257102.00543E04@usgs.gov>

Another way, if have a PC with MS Access, is to create an Access database with the ODBC drivers for SQL Server and Oracle, and setup the connect descriptors for them.

Then, whenever you have to, use the Access database as the "go-between", using queries within Access.

---

Bill Ferguson
U.S. Geological Survey - Minerals Information Team PO Box 25046, MS-750
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208  

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of chupit_at_gmail.com
> Sent: Thursday, January 26, 2006 8:02 AM
> To: cstephens16_at_gmail.com
> Cc: Oracle-L_at_freelists.org
> Subject: Re: data from sql server to oracle on linux
>
> The easiest would be to use odbc gateway
> (http://www.orafaq.com/faqgate.htm),
>
> But I would suggest you to write small application (in any
> language that you know, that can connect to MSSQL from
> linux), I would load MSSQL JDBC driver into Oracle and use
> Java Stored Procedures to implement this functionality (In
> fact we are using similar technique to load data into Oracle
> Server from SAP/FoxPro databases).
>
> You can search for "quick and dirty" ways in case when you
> want to perform data transfer only once, but if you will do
> this on regular basis, and data volume is unpredictable, than
> you have to find a way you will relay on.
>
> On 1/26/06, Chris Stephens <cstephens16_at_gmail.com> wrote:
> > What is the easiest (don't care about speed/efficiency)
> way of moving
> > data between sql server and oracle on linux? ...this is a process
> > that will have to be repeated on a regular basis and the list of
> > tables to move data from will change everytime.
> >
> > i was told...but have not confirmed that there is no
> gateway between
> > sql server and oracle on linux. ...that's what i'll be
> doing as soon
> > as i hit send.
> >
> > thanks for any suggestions!
> > chris
>
>
> --
> Best regards,
> Edgar Chupit
> callto://edgar.chupit
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 26 2006 - 09:22:06 CST