Re: Sybase tables

Hello,

This may not be appropriate, especially for large amounts of data, but you could install/use an ODBC Driver (actually two separate Drivers) to ATTACH each of the two (2) databases with Microsoft Access.

Once the Tables you need are ATTACHED, it's a fairly simple matter to create an APPEND Query that takes data from the Sybase Tables and puts it into the Oracle Tables.

Of course, there lots of small issues, such as Data Types, Indices, ... but in many cases this is very effective, viable solution.

Michael Rose

mmrose_at_home.com

• Original Message ----- From: "Glen Braden" <g.a.braden_at_larc.nasa.gov> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 20, 2000 5:19 PM 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 Tue Jun 20 2000 - 21:29:16 CDT