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