This discussion is archived
3 Replies Latest reply: May 24, 2012 1:29 AM by kgronau RSS

Data migration from Progress 9.1d to Oracle 10g

babarbaig82 Newbie
Currently Being Moderated
Hi,
I need to migrate data from Progress 9.1d to Oracle 10g. Please guide.


Thanks in Advance
  • 1. Re: Data migration from Progress 9.1d to Oracle 10g
    kgronau Guru
    Currently Being Moderated
    There's no automated tool from Oracle that can assist you with the migration.

    You can either export all data from your Progress database into flat files containing just ASCII data and then use SQL*Loader to load the content into the Oracle database. Another common way is to configure the Database Gateway for ODBC which allows you to connect from an Oracle database to a foreign database using a 3rd party ODBC driver and you can then use Pl/SQL or even SQL*Plus copy command to copy the data from your Progress database into Oracle. A 3rd option would be to use JAVA by for example loading the JDBC driver for the Postgres database into the Oracle JVM and then by writing some code that opens the connection and fetches data from the Postgres database into Oracle.


    More details can be found in the note Options for Connecting to Foreign Data Stores and Non-Oracle Databases - For Example - DB2, SQL*Server, Sybase, Informix, Teradata, MySQL (Doc ID 233876.1) which is available through My Oracle Support portal.

    Edited by: kgronau on May 24, 2012 10:28 AM
  • 2. Re: Data migration from Progress 9.1d to Oracle 10g
    931859 Newbie
    Currently Being Moderated
    I can't agree there is no tool for the automate performance of this task. I'm representing the vendor company of such a product SQLWays. You can go to ispirer.com to have more information about it. If you provide me with the data volume I'll be able to give you a quote.

    My e-mail: dmitry.samsonov@ispirer.com , skype: dmitry.samsonov. , phone: (415) 513 0178 , cell: +375 (29) 6194391.

    Feel free to contact me, will be glad to help.
  • 3. Re: Data migration from Progress 9.1d to Oracle 10g
    kgronau Guru
    Currently Being Moderated
    Thanks for pointing it out Dmitri. I've changed my last post to be more precise that Oracle isn't providing a utility that assists with Postgres migrations.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points