cancel
Showing results for 
Search instead for 
Did you mean: 

Migrate from Oracle19c to Postgresql

jdeviceb
Confirmed Champ
Confirmed Champ

Hello, we have installed version 7.2 of Alfresco and we want to migrate from Oracle19c to PostgreSQL. Any recommendations for tools to use?
Or does anyone know of any links with information on this subject?
Because I'm sure someone has already gone through the same thing as us.😋
Gracias

2 REPLIES 2

AlfrescoZZZ
Star Collaborator
Star Collaborator

Unfortunately, yes, but I should point out that mine was a migration of an even older version, basically we exported as sql the contents of the oracle database then imported it to postgres, but some stuff was missing (index, constraints, ecc.) and we had to build manualy some sql patching queries to do the link reconstruction for the tables, so at least in my experience there is no automatic tool for simply migrate tis just “brutal handmade fix" and numerous tests.

The solution I recommend today (and because version 7.2 is not very old) is to build up another alfresco 7.2 with postgres and use the rest api to transfer metadata and contents from one alfresco to another.

Hello:
Thanks for the reply. I was testing migrating a version 7.2 from Oracle to Postgreesql using ora2pg. There are minimal differences between some sequences and some tables, but I managed to get it to work without problems.
It is tedious to review the tables and format the fields to match what Alfresco expects, but it works without problems, at least what we have tested.
Summary:
1) create a new 7.2 Alfresco with Oracle
2) export the schema and load it into a Postgreesql database
3) create a new 7.2 Alfresco in Postgreesql
4) compare the Postgreesql schemas, the one exported from Oracle and the one created by Alfresco itself in Postgreesql.
5) adjust the field mapping and possible FIX (which are not a big deal)
6) Migrate the data.
and that's it...