Migrate SonarQube data from H2 database to H2 database

[syedsfayaz (syed)]

• SonarQube 7.5
• Linux
• H2 Database

I am trying to migrate and upgrade our SonarQube instance to the latest to which I can upgrade to. Can you please suggest how I can migrate the data and analysis to the new server.

[ganncamp (G Ann Campbell)]

Hi,

There’s a reason you see a warning banner at the bottom of each page. You cannot upgrade from H2. You should just start over in 9.0 with a production database. The docs list the requirements..

 
Ann

[syedsfayaz (syed)]

@ganncamp On the other post I saw a response that SonarSource DB copy tool can be used to copy data and this is available for customers with Support.

Anyone tried H2 Database migration with 3rd party tool?

Hi! I’m running SonarQube version 7.3 and because of oblivion all our data is in H2 Embedded database and not in Postgresql database. I’ve been reading quite a lot of different kind of discussions about H2 database migration and based on them I would say it’s not doable migrate H2 to Postgresql. But I have not found information would it be doable with third party tools like Full Convert. It will support H2 database migration to Postgresql but is there some other reasons what i should be aware o…

[ganncamp (G Ann Campbell)]

Hi,

The DB migration tool is to move from one supported DB to another. H2 is not supported for production.

 
Ann