This discussion is archived
1 Reply Latest reply: Apr 16, 2012 3:53 AM by mkirtley-Oracle RSS

How to migrate PostgreSQL to oracle10g

784368 Newbie
Currently Being Moderated
Hi ,

Please Help me with the steps or ways to migrate PostgreSQL to oracle10g (10.2.0.4 )
  • 1. Re: How to migrate PostgreSQL to oracle10g
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    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.

    Regards,
    Mike

Legend

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