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??
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.
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.