Re: Sybase to Oracle migration?
From: Stephen L. O'Hearn <soh1_at_ix.netcom.com>
Date: 1995/10/30
Message-ID: <472nuq$e7d_at_ixnews5.ix.netcom.com>#1/1
Date: 1995/10/30
Message-ID: <472nuq$e7d_at_ixnews5.ix.netcom.com>#1/1
In <DH9Gwx.I2p_at_gateway.hysoft.com> John_Falasco_at_hysoft.com (John
Falasco) writes:
>
>I am looking for a tool to migrate data from Sybase tables to Oracle
>tables. The data is held in approx 250 tables; all procs and triggers
>have been converted and the corresponding tables have been created
>(although if there's an easy way to do this, I'd love to hear about
>it!). If anyone has done this, I'd appreciate some advice. TIA,
>
>John
>
I would expect that Sybase has some ability to print out ASCII text files of its tables. And Oracle has a utility called SQL*Loader, which you should have with your installation of Oracle, that will read in ASCII text files and put the data into ORACLE tables.
- Steve O'Hearn