How to convert H2 dtabase verions 1.x to 2.x

[Serge Calderara]

Dear all,

We have a Jira DC instance which is using H2 database and Jira 9.1.

We were trying to upgrade the Jira version to Jira 9.12 but we notice that the upgrade did not convert the H2 version to the version of the installed Jira.

After some research we find out that this conversion need to be done manually before upgrading

So we have 2 option in our case :

1. Convert the H2 to Postgress
2. Leave as H2 but convert it to version 2.x

Does any one have an easy way or tool to proceed with this 2 steps ?

PS : We do not want to loose how H2 data even if we know that it should not be used in production instance. but we were quite surprise to see that when you update to a new version , the installer is not able to convert the H2 db as well

Thanks for your help

regards

[Fabio Racobaldo _Herzum_]

Hi @Serge Calderara ,

my suggestion is to migrate to Postgres (https://confluence.atlassian.com/adminjiraserver/switching-databases-938846867.html#Switchingdatabases-differenttype). H2 database is not supported for production environments so please try to test a db migration process in a test environment first.

Fabio