Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: data from sql server to oracle on linux

Re: data from sql server to oracle on linux

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 26 Jan 2006 15:37:42 +0000
Message-ID: <7765c8970601260737w336fbf55w8dcb0fca92a3b00c@mail.gmail.com>


I'd second the DTS suggestion. Its very easy, the default flows generated by the wizard aren't efficient but writing efficient ones is fairly straightforward and its all free.

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
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 26 2006 - 09:37:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US