Re: data from sql server to oracle on linux
- From: Edgar Chupit <chupit@xxxxxxxxx>
- To: cstephens16@xxxxxxxxx
- Date: Thu, 26 Jan 2006 17:01:43 +0200
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
