Re: Oracle Postgres Conversion

From: goutham goud <gouthamgoud(at)live(dot)com>
To: Gabriele Lohss <gabriele(dot)lohss(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Oracle Postgres Conversion
Date: 2014-05-26 17:42:42
Message-ID: BAY175-W11A9FCCA3CFC689867BF11D73B0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hey, sorry I did not read your message properly, You can use ora2pg for doing initial dumps and probably tools like symmetricds for cross database replication.

ThanksGoutham
From: gouthamgoud(at)live(dot)com
To: gabriele(dot)lohss(at)gmail(dot)com; pgsql-admin(at)postgresql(dot)org
Subject: RE: [ADMIN] Oracle Postgres Conversion
Date: Mon, 26 May 2014 23:04:58 +0530

Ora2pg works perfectly. Try it !!

ThanksGoutham
Date: Mon, 26 May 2014 14:28:58 +0200
Subject: [ADMIN] Oracle Postgres Conversion
From: gabriele(dot)lohss(at)gmail(dot)com
To: pgsql-admin(at)postgresql(dot)org

Hi,

I'm looking for a nice tool for a Oracle to Postgres-Conversion. Currently we're runnning python-scripts collecting data from the oracle and updating in the postgres every 3 hours. but whta we really need is a nearly up-to-date clone of the oracle which will be used in our productive systems for the next couple of years. We don't want to migrate, we just need a proper replication procedure.

Has anyone experience with tools like the xDBReplicationmanager of EnterpriseDB or ora2pg?

Thanks for any hints.

Regards,
Gaby

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message om prash jaiswal 2014-05-27 05:37:45 Re: Doubt about pg_upgrade with link mode
Previous Message goutham goud 2014-05-26 17:34:58 Re: Oracle Postgres Conversion