pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedOracle Postgres Conversion
5+ messages / 3 participants
[nested] [flat]
* Oracle Postgres Conversion
@ 2014-05-26 12:28 Gabriele Lohss <gabriele.lohss@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: Gabriele Lohss @ 2014-05-26 12:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle Postgres Conversion
@ 2014-05-26 17:34 goutham goud <gouthamgoud@live.com>
parent: Gabriele Lohss <gabriele.lohss@gmail.com>
0 siblings, 1 reply; 5+ messages in thread
From: goutham goud @ 2014-05-26 17:34 UTC (permalink / raw)
To: Gabriele Lohss <gabriele.lohss@gmail.com>; pgsql-admin
Ora2pg works perfectly. Try it !!
ThanksGoutham
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
=
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle Postgres Conversion
@ 2014-05-26 17:42 goutham goud <gouthamgoud@live.com>
parent: goutham goud <gouthamgoud@live.com>
0 siblings, 1 reply; 5+ messages in thread
From: goutham goud @ 2014-05-26 17:42 UTC (permalink / raw)
To: Gabriele Lohss <gabriele.lohss@gmail.com>; 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@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 !!
ThanksGoutham
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
=
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle Postgres Conversion
@ 2014-06-04 10:29 Gabriele Lohss <gabriele.lohss@gmail.com>
parent: goutham goud <gouthamgoud@live.com>
0 siblings, 1 reply; 5+ messages in thread
From: Gabriele Lohss @ 2014-06-04 10:29 UTC (permalink / raw)
To: goutham goud <gouthamgoud@live.com>; +Cc: pgsql-admin
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Oracle Postgres Conversion
@ 2014-06-10 09:24 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Gabriele Lohss <gabriele.lohss@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Albe Laurenz @ 2014-06-10 09:24 UTC (permalink / raw)
To: Gabriele Lohss *EXTERN* <gabriele.lohss@gmail.com>; goutham goud <gouthamgoud@live.com>; +Cc: pgsql-admin
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2014-06-10 09:24 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-05-26 12:28 Oracle Postgres Conversion Gabriele Lohss <gabriele.lohss@gmail.com>
2014-05-26 17:34 ` goutham goud <gouthamgoud@live.com>
2014-05-26 17:42 ` goutham goud <gouthamgoud@live.com>
2014-06-04 10:29 ` Gabriele Lohss <gabriele.lohss@gmail.com>
2014-06-10 09:24 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox