Re: data from sql server to oracle on linux

Personally, I find Perl with DBI/DBD::Oracle and ODBC or ADO pretty hard to beat for this kind of task.

Connect to both databases simultaneously, transfer from one to the other, ETL on the fly if needed.

Works from either end (win32 or linux)

Jared

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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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