RE: Sybase tables

I am not too familiar with the sybase side of things. I was just wondering if there
was a utility (like ACCESS Migration Aid) that could be used. Thanks for the confirmations/
suggestions.

At 07:36 AM 6/21/00 -0800, you wrote:
>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).
> >
>--
>Author: Shawn Ferris
> INET: Shawn.Ferris_at_twtelecom.com
>
>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).

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,