Forum OpenACS Q&A: Re: Oracle to Postgres migration

Collapse
Posted by Dave Bauer on
I believe what we did for an Oracle to PG migration was to do a clean install of OpenACS into Postgresql, then load the data on top of that using ora2pg with some custom SQL.

This means all the stored procedures etc do not need to be ported at all, unless you are using custom non-PG packges but you can write sql install scripts for those instead of trying to automate it.

The only catch is to match sure the few initial install object_ids match up and that you don't have any object_id conflicts when loading the data.