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

Serge Calderara April 23, 2024

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


1 answer

0 votes
Fabio Racobaldo _Herzum_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 24, 2024

Hi @Serge Calderara ,

my suggestion is to migrate to Postgres ( H2 database is not supported for production environments so please try to test a db migration process in a test environment first.


Suggest an answer

Log in or Sign up to answer