1 Reply Latest reply: Jul 21, 2014 2:31 AM by Mkirtley-Oracle RSS

    Transfering Data From PostgreSQL DB to Oracle DB

    Charith Kulawardana

      Dear Experts,


      I have Adempiere application and it's using PostgreSQL 9.1 DB.

      What I want to do is, I want to transfer whole data,which are updating to the Postgres DB to Oracle DB.

      I already created whole table structure in Postgres DB to Oracle DB.

      Is there any script or any other method to schedule for updating data from Postgresql DB to Oracle DB for a given time.

      Thank you



        • 1. Re: Transfering Data From PostgreSQL DB to Oracle DB


            If this is a one-off move then you could extract the Postgres data and use SQL*Loader scripts toput it into the Oracle tables.

          If you want to do it over a period of time then you could use the Database Gateway for ODBC (DG4ODBC) to connect to the Postgres database from Oracle using database links and then access the Postgres data.

          If you have access to My Oracle Support there is further information in these notes -


          Master Note for Oracle Gateway Products (Doc ID 1083703.1)


          This has links to further information and the configuration notes for DG4ODBC for various platforms.
          This note has alternatives for making a migration -


          How To Migrate Non-Oracle Databases For Which a SQL*Developer or Migration Workbench Option Is Not Available (Doc ID 393760.1)