Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WoyvC-0004kJ-QL for pgsql-admin@arkaria.postgresql.org; Mon, 26 May 2014 17:42:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WoyvC-0005ro-8D for pgsql-admin@arkaria.postgresql.org; Mon, 26 May 2014 17:42:50 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1WoyvB-0005rf-2p for pgsql-admin@postgresql.org; Mon, 26 May 2014 17:42:49 +0000 Received: from bay004-omc3s5.hotmail.com ([65.54.190.143]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Woyv7-0002s2-AQ for pgsql-admin@postgresql.org; Mon, 26 May 2014 17:42:47 +0000 Received: from BAY175-W11 ([65.54.190.189]) by BAY004-OMC3S5.hotmail.com with Microsoft SMTPSVC(7.5.7601.22678); Mon, 26 May 2014 10:42:43 -0700 X-TMN: [Q8n2iXGIRRiHBpQkfPNHKLxRZAevFb4E] X-Originating-Email: [gouthamgoud@live.com] Message-ID: Content-Type: multipart/alternative; boundary="_27b8d911-25fc-4654-92a8-eb75c7f415b1_" From: goutham goud To: Gabriele Lohss , "pgsql-admin@postgresql.org" Subject: Re: Oracle Postgres Conversion Date: Mon, 26 May 2014 23:12:42 +0530 Importance: Normal In-Reply-To: References: , MIME-Version: 1.0 X-OriginalArrivalTime: 26 May 2014 17:42:43.0234 (UTC) FILETIME=[E5B1E020:01CF7909] X-Pg-Spam-Score: 0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --_27b8d911-25fc-4654-92a8-eb75c7f415b1_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hey=2C sorry I did not read your message properly=2C 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=3B pgsql-admin@postgresql.org Subject: RE: [ADMIN] Oracle Postgres Conversion Date: Mon=2C 26 May 2014 23:04:58 +0530 =0A= =0A= =0A= Ora2pg works perfectly. Try it !! ThanksGoutham Date: Mon=2C 26 May 2014 14:28:58 +0200 Subject: [ADMIN] Oracle Postgres Conversion From: gabriele.lohss@gmail.com To: pgsql-admin@postgresql.org Hi=2C 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-da= te clone of the oracle which will be used in our productive systems for the= next couple of years. We don't want to migrate=2C we just need a proper re= plication procedure.=20 =0A= Has anyone experience with tools like the xDBReplicationmanager of Enterpri= seDB or ora2pg? Thanks for any hints. Regards=2C Gaby=20 = --_27b8d911-25fc-4654-92a8-eb75c7f415b1_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hey=2C sorry I did not read your= message properly=2C You can use ora2pg for doing initial dumps and probabl= y tools like symmetricds for cross database replication.



Tha= nks
Goutham

From: gouthamgou= d@live.com
To: gabriele.lohss@gmail.com=3B pgsql-admin@postgresql.orgSubject: RE: [ADMIN] Oracle Postgres Conversion
Date: Mon=2C 26 May 201= 4 23:04:58 +0530

=0A= =0A= =0A=
Ora2pg works perfectly. Try it !!


<= /div>
Thanks
Goutham

Date: Mon=2C 26 May 2014 14:28:58 +0200
Subject: [ADMIN] Oracle Po= stgres Conversion
From: gabriele.lohss@gmail.com
To: pgsql-admin@post= gresql.org

Hi=2C

I= 'm looking for a nice tool for a Oracle to Postgres-Conversion. Currently w= e're runnning python-scripts collecting data from the oracle and updating i= n the postgres every 3 hours. but whta we really need is a nearly up-to-dat= e clone of the oracle which will be used in our productive systems for the = next couple of years. We don't want to migrate=2C we just need a proper rep= lication procedure.
=0A=
Has anyone experience with tools like the xDBReplicationmanager of Ente= rpriseDB or ora2pg?

Thanks for any hints.

Regards= =2C
Gaby
=
= --_27b8d911-25fc-4654-92a8-eb75c7f415b1_--