Re: Oracle to Postgres migration open source tool

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Oracle to Postgres migration open source tool
Date: 2011-07-07 14:14:07
Message-ID: 20110707141407.GA56515@shinkuro.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 07, 2011 at 09:55:45AM -0400, akp geek wrote:
> Hi all -
>
> Are there any open source tools available for migrating from
> oracle to postgres. We have 20 tables in oracles that we needed to get to
> postgres. Appreciate your help

I have used ora2pg. It was not seamless -- I had to do some whacking
around of the produced files, and I had a pretty good idea of what
changes were needed in the ora2pg tool to improve things, but I didn't
have time to implement them. It was still a lot easier than trying to
do it all by hand.

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2011-07-07 14:21:11 Re: Streaming replication on 9.1-beta2 after pg_restore is very slow
Previous Message David Johnston 2011-07-07 14:09:23 Re: Trying to find miss and mister of the last month with highest rating