2 Replies Latest reply: Mar 5, 2012 8:46 AM by 909975 RSS

    oracle to postgres replication

    803103
      hi!
      i`m trying to replicate data(one direction) from oracle 11gR2 to postgresql 8.4.9. The database in postgres has different structure of tables from database in oracle.
      can anyone help me to tell which is the best way to do this??

      thanks Flag.
        • 1. Re: oracle to postgres replication
          Ranjith
          Hi,

          Porting Oracle SQL to postgre SQL is a complex one. as u said there are lot of structural changes needed to be done.
          Here is the link that gives u some ideas.

          http://wiki.postgresql.org/wiki/Oracle_to_Postgres_Conversion

          U gonna try with Migration or replication ?
          May be golden gate is help to replicate oracle to postgreSQL.
          But goldengate also have lot oflimitations.Check the bellow link tofind that.

          http://goldengateconfig.com/2011/03/

          Thanks,
          Ranjith
          • 2. Re: oracle to postgres replication
            909975
            you use ant ETL tool like Talend or Pentaho Kettle solution...