NUXEO upgrade-from 5.3.2 to 5.5

[elvis_]

Hi All, I am running nuxeo5.3.2 in a debian with default database(h2). I tried to upgrade nuxeo to 5.5 with postgresql as a database, but didn't succeed!!! Can anybody tell me how can i take sql dump from h2 or a way to upgrade from 5.3 to 5.5. Hope somebody help me.. Thanks in advance

[elvis_]

Hello, Can anybody help me please ??

[bruce_Grant]

Have you tried upgrading to 5.5 without changing the database? That is, make sure the upgrade in place works. Once you have moved to 5.5 then you can figure out how to change migrate the database platform.

[elvis_]

Hi Bruce,

[bruce_Grant]

This is where the documentation is a little on the light side. I will be trying the same in the next few weeks and will let you know what happens, however, I'm using Postgresql.

[elvis_]

I tried upgrading to 5.5 without changing the database by copying the folders

[Julien_Carsique]

Hi,

As suggested by bruce, you could first upgrade, then change the database. But I would recommend to start with the migration from h2 to PostgreSQL, then upgrade (that order may be easier and stronger: since H2 is dedicated to development environments, we don't care a lot about upgrading H2 data).

About SQL dump from H2, there is a lot of information on Internet, including dedicated information about Nuxeo (I remember this has been discussed a lot on the forum, mailing lists, ...). Maybe that old script could help you.

You could also use the Nuxeo export feature then import your data in a Nuxeo configured to use PostgreSQL.

All upgrades are described in the How to upgrade Nuxeo documentation. You will have to upgrade step by step from 5.3.2 to 5.6, not directly. Think to carefully read upgrade notes about PostgreSQL.