Re: Data from Oracle to Sybase

Hi,

When exporting to flat file for loading by bcp.exe there can be problems with char columns containing commas, you have to enclose them by quotes to load correctly to Sybase.
There are no such problems when using Perl.

Best regards, Dmitry

--
http://www.ispirer.com/products/ - Database migration tool for IBM DB2,
Oracle, MS SQL Server, Sybase and MySQL.

"Ron Reidy" <rereidy_at_indra.com> wrote in message
news:3D074860.61225BA2_at_indra.com...


> Ed prochak wrote:

> >

> > "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

> Or...you can dump the data from Oracle (via sqlplus, or perl, or

> whatever)  into a file and use bcp to get it into sybase.

> --

> Ron Reidy

> Oracle DBA