Re: Move/insert data from MSSql to Oracle on Unix

Jan Birk wrote:
> I have a MSSql and would like to move data between the MSSql and Oracle
> on Unix.
>
> How do I do that?
>
> I could use bcp on MSSql and Sqlldr on Unix, but I would prefer an
> insert or similar..... Is it possible?
>
> Thanks and best regards
>
> /Jan

Have you looked at Oracle's Transparent Gateway? With this, you create a

   database link from Oracle to msSQL. You can then INSERT or SELECT through the link depending on which way you want to go. Please check the Oracle docs for more details.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown