Data migration out of H2 Database

Dear Community,

I have been using SonarQube version 6.5 for my projects. I had been using the embedded H2 database and hadn’t used a separate database for storing the SonarQube analysis data.

I want to upgrade the version of SonarQube from 6.5 to 7.8 but SonarQube’s UI says I cannot upgrade without losing the data or migrate the data out of the installed SonarQube 6.5 and attach it with the upgraded database later.

How do I upgrade and still be able to save the data somehow? I know the official application says its not supported but is there a hack or something to save the data, as the data is really important.

If there is any possible alternative way for performing the upgradation so that I don’t lose data, please do suggest.

Regards,
Sid

Hi Sid,

You already know the official answer, so I won’t belabor it: you can’t migrate. You need to start over. (And maybe my answer will draw someone out of the woodwork to give you a hack and prove me wrong. Good luck, but I wouldn’t hold my breath…)

Now that that’s out of the way, I need to point out that 7.8 is past EOL. Since you’ll be starting over, you should do so with either 8.9.2, the current LTS, or 9.0.1, the Latest version.

 
Ann