Re: Ingres to Postgres migration

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.