Re: Sybase to Oracle Conversion

The easiest way to convert would probably be to use a third-party one that talks to both databases - e.g., Access or Powerbuilder - though these in particular would be relatively slow and possibly blow up on data volume, but you get the idea.

I think the fastest way to do this would be to write a C program to read from Sybase and write to Oracle.

Aside from that, probably the easiest way would be to write out flat files using isql. The Sybase docs on isql should walk you through this OK. Haven't tried using it to parse out .ctl files - must try it now...

hth -

Regards,
jh

Kevin L. Kitts wrote:

> Hello,
> I am in the process of converting a Sybase database (PCDOCS is the
> application I am converting) to an Oracle database. I am an experienced
> Oracle DBA - unfortunately my knowledge of Sybase is limited. Has anyone
> here done such a conversion and if so do you know of any tools that can
> easily extract the data from the 66 tables I am converting and perhaps
> write the control files for SQL*Loader (which I plan to use to import the
> data into Oracle)?
>
> Any tips or techniques would be most apprec.
>
> Thanks,
>
> Kevin

--
Jared Hecker
jared_at_hwai.com
***
*****LEGAL NOTICE TO ALL BULK E-MAILERS*****
NOTICE TO BULK EMAILERS: Pursuant to US Code, Title 47, Chapter 5,
Subchapter II, page 227, any and all non solicited commercial E-mail sent to
this address is subject to a download and archival fee in the amount of $500
US. E-mailing denotes acceptance of these terms and this kind of email is
being collected and will be reported to authorities and agency for
collection.