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

Collapse
4: Re: Oracle to Postgres migration (response to 1)
Posted by Tracy Adams on 09/26/05 01:58 AM
I've done some major migrations - including for Sloan (3.4 to 4.x) and from Oracle to Postgres for Guatamela (3.4 to 5.x)

Since the data model is fairly complex and doesn't always involve a 1-to-1 table mapping and involved various business logic, I built an engine that would

a) first query the old site for a given type of data (user, group, group membership, forum post, etc)

b) use the APIs of the new site to recreate the data

c) store various mappings like the user id in the old system to the user id in the new system. This allowed me to port things like the author of the bboard message

Collapse
8: Re: Re: Oracle to Postgres migration (response to 4)
Posted by Rocael Hernández Rizzardini on 11/04/05 12:16 AM
The migration to postgres shouldn't be a big deal for the standard OpenACS packages. And probably a good path will be to follow the process that Tracy created for 3.x to 5.x to ensure that everything works fine. A direct tool will be worth to test it as well, and if you previously move your lobs of the CR to the file system, even easy.