Re: Migration Experiences to Oracle

Dear Geoff,
Here's my two cents worth:

I don't think you can simply take a dump from Sybase/Progress and just import it into your Oracle DBMS. To port data from Sybase/Progress to Oracle, you need to perform a bulk copy (bcp) of each of your Sybase/Progress table into a comma-delimited ASCII flat file, and then use Oracle's SQL-Loader (sqlldr) utility to read the data in from the corresponding flat file. Of course, prior to this you must have all your previous DDL statements in Sybase/Progress converted into Oracle. The order to populate your Oracle tables will also depend on referential integrity constraints defined on your tables.

Other things that you may need to do:
1. Convert stored procedures, functions and triggers into their corresponding Oracle DDLs
2. Disable triggers when using SQL-Loader. Enable triggers after the data migration has been completed.
3. Change certain Sybase/Progress specific functions into their equivalent in Oracle, e.g. Sybase uses CONVERT whereas Oracle uses TO_DATE/TO_CHAR for date/time manipulation.
4. Determine the impact to your applications and how queries were written in the database layer.
5. Contact your Oracle representative. They should be more than willing to help someone who wants to move away from their competitors.

Regards,
Simon.

Please reply to angsy_at_pacific.net.sg

"Geoff_Turner" <gturner1052_at_yahoo.com> wrote in message news:9e96d7e0.0106141006.fdc05bf_at_posting.google.com...
> Our company is currently looking at converting from our SYBASE and
> PROGRESS environment to an Oracle DBMS. If you have undergone either
> of these migrations I would appreciate war stories or success
> formulas. Thank you.
Received on Mon Jun 18 2001 - 17:40:46 CEST