oracle to pg

[danny6360]

Hi all,

I have a question... our company has a centralised oracle database and few postgress clinets .. we want to replicate or copy a perticular table and column from oracle to pg..

is there any way we can do it with out using any tools in postgress.... oracle should not push the change but postgress should pull the information from oracle..


thx,
Danny

[ssnaik84]

is there any way we can do it with out using any tools in postgress

Do you want to migrate database without tools?

if not, EnterpriseDB has good migration support

[legend97]

If you are not looking to migrate the database, EnterpriseDB also has a replication tool that replicates data from Oracle to Postgres Plus Advanced Server(based on PostgreSQL).

That is a trigger based replication solution. If that doesn't work for you, then you might want to take a look at database links in Postgres Plus Advanced Server. They allow you to create a link between Postgres Plus Advanced Server to Oracle. Then you can create job in the Postgres Plus Advanced Server database that will routinely pull the data, over the link, from Oracle to Advanced Server.

http://www.enterprisedb.com/docs/en/8.3R2/oracompat/EnterpriseDB_OraCompat_8.3-22.htm#P1970_112702