Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> 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 CST