This discussion is archived
2 Replies Latest reply: Mar 5, 2012 6:46 AM by 909975 RSS

oracle to postgres replication

803103 Newbie
Currently Being Moderated
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 Explorer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    you use ant ETL tool like Talend or Pentaho Kettle solution...

Legend

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