1 Reply Latest reply: Apr 16, 2012 5:53 AM by Mkirtley-Oracle RSS

    How to migrate PostgreSQL to oracle10g

      Hi ,

      Please Help me with the steps or ways to migrate PostgreSQL to oracle10g ( )
        • 1. Re: How to migrate PostgreSQL to oracle10g
          We do not have any tools to migrate PostgresSQL directly to Oracle. the Sql*developer migration workbench does not support Postgres.
          The only alternatives are -

          - use the Database Gateway for ODBC (DG4ODBC) to select from Postgres tables and insert into Oracle.
          - export the data from Postgres into flat files and use SQL*Loader to load the data into Oracle.
          - You could add a Postgres JDBC driver into the Oracle database Java interface and then code to open the connection and to the fetch of the data.

          You may be able to find 3rd party tools or vendors that could help with a migration but you will have to make a search for those.