Hi i want upgrade sonarqube db to psql from existing h2 db without any data loss how should i get my h2 data into psql db please need correct way to chnage db withou any data loss from h2 db.

There’s no supported way to migrate the data from the h2 database. [image] Migrate H2 database for SonarQube version upgrade SonarQube Hey there. On every page, while using the embedded database, there is a big warning that it is not suitable for production use and not p…

So We have a huge data in existing sonarqube h2 db is any alternative way to get that data backup migration possible

I don´t know if it is works for all versions but I have managed to migrate from H2 to PostgreSQL using 8.9.10 LTS CE version. What I did was to use Squirrel SQL client and use the Embedded H2 and PostgreSQL drivers and copy the data from one database to the other. The “trick” for connecting to the…

Upgrade sonarqube to psql without data loss from h2 database

SonarQube Server / Community Build

felipebz (Felipe Zorzo) August 28, 2022, 2:33pm 2

There’s no supported way to migrate the data from the h2 database.

2 Likes

Topic		Replies	Views
Sonarqube H2 DB data migration to new PSQL DB SonarQube Server / Community Build sonarqube	2	770	August 23, 2023
Migrate H2 database for SonarQube version upgrade SonarQube Server / Community Build sonarqube , database , h2 , migration , 8-9-lts-upgrade	3	4301	August 23, 2023
Anyone tried H2 Database migration with 3rd party tool? SonarQube Server / Community Build	2	2090	August 23, 2023
Data migration out of H2 Database SonarQube Server / Community Build	4	1076	August 25, 2023
Migrate SonarQube data from H2 database to H2 database SonarQube Server / Community Build	3	1939	October 15, 2021

Upgrade sonarqube to psql without data loss from h2 database

Related topics