Re: Data from Oracle to Sybase

"Amy Schuele" <aschuele_at_ncsa.uiuc.edu> wrote in message news:<PS1N8.12865$U7.148549_at_vixen.cso.uiuc.edu>...
> Hello,
>
> We need to copy some of our data from an Oracle 8i database to
> our Sybase ASE database.
>
> I've looked at the Oracle Export utility, but can't find a way for
> us to parse the binary that it is saved into.
>
> We can write a perl script to get the data, save it in Perl to a data
> structure
> and insert it into our Sybase database, but that will be very slow.
>
> I'd like to find some way to dump the data from Oracle so we can use
> bcp to load it into Sybase. Do any of you know what Oracle tool will
> allow me to do this?
>
> Thanks!
> Amy
> aschuele_at_ncsa.uiuc.edu

Assuming you use the perl DBI, you can access ORALCE pretty much the same way you do SYBASE. (open a connection to ORACLE and one to SYBASE, query the data from ORACLE, insert the data in SYBASE, close connections and exit.)

out of ORACLE into SYBASE
Nothing but PERL

HTH
   Ed Received on Tue Jun 11 2002 - 12:49:14 CDT