RE: Sybase tables

I wrote such a beast in Perl using the DBI/DBD::Oracle/DBD::Sybase modules. It will build the Oracle table definition from the Sybase data dictionary, open a cursor in each and dump record after record from sybase to oracle. Fairly fast.. 1/4 million rows < 10minutes. (fairly simple and stupid) There are many ways it could be improved upon and cleaned up. (hey, I wrote it in like 30minutes) 8)

Shawn M Ferris
Oracle DBA - Time Warner Telecom

> -----Original Message-----
> From: Glen Braden [mailto:g.a.braden_at_larc.nasa.gov]
> Sent: Tuesday, June 20, 2000 3:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Sybase tables
>
>
> Does anyone have a technique to load sybase tables (data)
> into oracle tables?
>
> I am thinking that sybase must create a flatfile, and the
> flatfile is used
> by sqlloader.
>
> Is this correct?
>
> Glen A Braden g.a.braden_at_larc.nasa.gov
> DBA gbraden_at_visi.net
> ICQ#33298579
> (757) 865-8440 x130 http://sun1misb.larc.nasa.gov/bamis/
> (757) 865-6426 Fax ADABAS 6.2.1 NATURAL 2.2.8++ TRIM 6.1.0
> NCI Information Systems SUPERNATURAL 3.1.5 MVS/OS 390 CICS 4.3
> ORACLE 6 (don't Ask),
> ORACLE 7,
> ORACLE 8
>
> --
> Author: Glen Braden
> INET: g.a.braden_at_larc.nasa.gov
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jun 21 2000 - 09:27:04 CDT