Re: Export data from Oracle to another SQL server ???

On a related subject:
I am trying to export data from an Oracle DB for other reasons, and all I need is ASCII fixed or delimited. It seems that the EXP & SQLLoader products do Oracle specific formatting which I don't want. Is there a better way to do this without having to get a 3rd party product. I'd rather do this without having to spool SELECT statements or buying more software.

Thanks in advance,
Brian Hall

Peder Holst wrote:

> Sergei,
> For the migration or replication of data between the two - check and
> download
> SQLMover from http://www.sqlmover.com. It handles Oracle LONG, SQL Server
> Text, Image and Binary datatypes. Use the Intersolv ODBC driver for Oracle
> and the full evaluation key 1KKJBFJYF for SQLMover.
> Peder Holst
> pederh_at_elektrosoft.se
>
> Sergei Didur <sdidur_at_notes.cc.bellcore.com> wrote in article
> <01bcfe67$7733c7a0$79a06080_at_sdidur-1>...
> > Hi everybody !
> >
> > I'd like to unload data from Oracle DB and then load it to Sybase.
> > I'm looking for something like Sybase BCP utility for Oracle.
> >
> > Thanks in advance,
> > Sergei Didur
> >
Received on Wed Dec 03 1997 - 00:00:00 CET