Thread: Oracle Postgres Conversion

Oracle Postgres Conversion

From
Gabriele Lohss
Date:
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

Re: Oracle Postgres Conversion

From
goutham goud
Date:
Ora2pg works perfectly. Try it !!


Thanks
Goutham


Date: Mon, 26 May 2014 14:28:58 +0200
Subject: [ADMIN] Oracle Postgres Conversion
From: gabriele.lohss@gmail.com
To: pgsql-admin@postgresql.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

Re: Oracle Postgres Conversion

From
goutham goud
Date:
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.



Thanks
Goutham


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

Ora2pg works perfectly. Try it !!


Thanks
Goutham


Date: Mon, 26 May 2014 14:28:58 +0200
Subject: [ADMIN] Oracle Postgres Conversion
From: gabriele.lohss@gmail.com
To: pgsql-admin@postgresql.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

Re: Oracle Postgres Conversion

From
Gabriele Lohss
Date:
Hi,

 thanks for all tipps. Do you know if ora2pg and oracle_fdw support postgis or geographical datatypes like oracle locator?

regards,
gaby


2014-05-26 19:42 GMT+02:00 goutham goud <gouthamgoud@live.com>:
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.



Thanks
Goutham


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


Ora2pg works perfectly. Try it !!


Thanks
Goutham


Date: Mon, 26 May 2014 14:28:58 +0200
Subject: [ADMIN] Oracle Postgres Conversion
From: gabriele.lohss@gmail.com
To: pgsql-admin@postgresql.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

Re: Oracle Postgres Conversion

From
Albe Laurenz
Date:
Gabriele Lohss wrote:
> thanks for all tipps. Do you know if ora2pg and oracle_fdw support postgis or geographical datatypes
> like oracle locator?

oracle_fdw does not support these.
I have had requests for that but lack the expertise.
Is there a compatible format for both PostGIS and Oracle Locator?
If yes, you could use views and pass the field through as binary data.

Yours,
Laurenz Albe