We moved from Oracle to PostgreSQL recently and just used the \copy command with csv files. To get the data out of oracle we wrote a small php script to connect to Oracle and then generate the csv files. The way it works is each csv file represented a database table. The copy command is amazingly fast...like faster than you would think is possible. I did have to do the database schema by hand, but we only had 110 tables so it was pretty easy. And by hand I mean I used an Oracle client tool to grab the table/index/sequence creation sql and then copied that into a separate file. It worked really well and wasn't that much work. It also gave me a chance to clean up the schema.
I did spend some time looking at tools (scripts, frameworks) to do the migration automatically but none worked very well. With the \copy command you really have all you need.
On Wed, Apr 30, 2014 at 8:06 AM, Michael Bostock <bostock83@gmail.com> wrote:
Hi,
We are using an old version of Ingres (3.0.1) and I have been asked to investigate the possibility of migrating to PostgreSQL (9.3.4). I was just wondering if there is any general advice you can give me or if there are any details/tools that will help with the migration.
