Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXuWs-00078n-UZ for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2013 14:30:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UXuWs-00045s-0h for pgsql-admin@arkaria.postgresql.org; Thu, 02 May 2013 14:30:38 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXuWr-00045n-2l for pgsql-admin@postgresql.org; Thu, 02 May 2013 14:30:37 +0000 Received: from dukecmfep05.coxmail.com ([68.99.120.40]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UXuWg-0006bO-Dx for pgsql-admin@postgresql.org; Thu, 02 May 2013 14:30:36 +0000 Received: from dukecmimpo02.coxmail.com ([68.99.120.135]) by dukecmfep05.coxmail.com (InterMail vM.8.01.05.08 201-2260-151-120-20120517) with ESMTP id <20130502143024.KHYF2988.dukecmfep05.coxmail.com@dukecmimpo02.coxmail.com> for ; Thu, 2 May 2013 10:30:24 -0400 Received: from valen.pnlassociates.com ([98.172.21.99]) by dukecmimpo02.coxmail.com with bizsmtp id X2WP1l00J28G7zW012WQWm; Thu, 02 May 2013 10:30:24 -0400 Authentication-Results: coxmail.com; auth=pass CRAM-MD5 smtp.auth=paul.a@pnlassociates.com Message-ID: <5182787F.1070501@pnlassociates.com> Date: Thu, 02 May 2013 10:30:23 -0400 From: "Paul B. Anderson" User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.8; rv:17.0) Gecko/20130328 Thunderbird/17.0.5 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Migration from Oracle 11g to Postgresql References: In-Reply-To: Content-Type: multipart/alternative; boundary="------------000404050707010709050209" X-Pg-Spam-Score: -1.9 (-) 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 This is a multi-part message in MIME format. --------------000404050707010709050209 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit There is also ora2pg. I have not tried it but it looks easy. http://ora2pg.darold.net/ On 5/2/13 10:18 AM, Leonardo Carneiro wrote: > I used full convert to convert firebird DBs to postgresql. with a few > tweaks, works like a charm. never tried with oracle. > > > On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar > wrote: > > > On May 2, 2013, at 9:57 AM, Silvana Bravo > wrote: > > > Hello, I'm planning a migration of production DBs from Oracle to > > Postgresql. I would like to receive some suggestions, advising > or links to > > related subjects. I decided to rewrite all store procedures, > that is not a > > problem. But regarding the data I was thinking in migrating > schema by > > schema. First, create all table structures in postgresql schema. > Then, > > generate inserts statements from Oracle schema to extract all > data. Addapt > > those inserts to the .sql script/s in postgresql schema. > > I'm currently making a POC of that process since the schemas to > migrate are > > not so big. Only a few tables have around 1.000.000 of rows. > > That would be the manual migration. Are there some other ways to > make this? > > > > Thanks for the support and I'm glad to start with postgres. > > > You can use Migration Tool kit or xDB Replication solution from > Oracle to PostgreSQL. > http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51.htm#P6096_508028 > > Thanks & Regards, > Vibhor Kumar > Blogs:http://vibhork.blogspot.com > http://vibhorkumar.wordpress.com > > > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org > ) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > --------------000404050707010709050209 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit There is also ora2pg.  I have not tried it but it looks easy.  http://ora2pg.darold.net/
On 5/2/13 10:18 AM, Leonardo Carneiro wrote:
I used full convert to convert firebird DBs to postgresql. with a few tweaks, works like a charm. never tried with oracle.


On Thu, May 2, 2013 at 11:09 AM, Vibhor Kumar <vibhor.aim@gmail.com> wrote:

On May 2, 2013, at 9:57 AM, Silvana Bravo <bravo.silver@gmail.com> wrote:

> Hello, I'm planning a migration of production DBs from Oracle to
> Postgresql. I would like to receive some suggestions, advising or links to
> related subjects. I decided to rewrite all store procedures, that is not a
> problem.  But regarding the data I was thinking in migrating schema by
> schema. First, create all table structures in postgresql schema. Then,
> generate inserts statements from Oracle schema to extract all data. Addapt
> those inserts to the .sql script/s in postgresql schema.
> I'm currently making a POC of that process since the schemas to migrate are
> not so big. Only a few tables have around 1.000.000 of rows.
> That would be the manual migration. Are there some other ways to make this?
>
> Thanks for the support and I'm glad to start with postgres.


You can use Migration Tool kit or xDB Replication solution from Oracle to PostgreSQL.
http://www.enterprisedb.com/docs/en/9.2/repguide/Postgres_Plus_xDB_Replication_Server_Users_Guide-51.htm#P6096_508028

Thanks & Regards,
Vibhor Kumar
Blogs:http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


--------------000404050707010709050209--