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

Brian Peasland wrote:
> 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
>
> --

>From SQL Server you might be able to use a Linked Database to push or
pull the data from the SQL Server side. You have to install an Oracle client on the MS server, then install the Windows ODBC and OLE pieces, plus you must configure MSDTC to allow remote activity.

>From Oracle you might be able to use the Generic Connectivity feature,
but this requires an ODBC driver for the Oracle server platform and you normally have to buy these from a third party.

Or you can buy the Transparent Gateway as Brian mentioned.

HTH -- Mark D Powell -- Received on Wed Oct 04 2006 - 10:11:11 CDT