Migrating SonarQube from H2 Database to PostgreSQL Without Data Loss

SonarQube Server / Community Build
, , ,
1

Hi everyone,
I recently faced the challenge of migrating SonarQube from an H2 database to PostgreSQL without losing any data. After extensive research and testing, I developed a solution that worked seamlessly for my setup. I’ve documented the entire process in a blog post on Medium, which you can find here: Migrating SonarQube from H2 Database to PostgreSQL Without Data Loss | by Karim Abouelfadl | Jan, 2025 | Medium.

In this guide, I cover:

  1. Prerequisites for the migration.
  2. Step-by-step instructions for exporting and importing data.
  3. Common pitfalls and how to avoid them.

I hope this helps others facing the same issue. Feel free to ask questions or share your feedback!

Best regards,
Karim Abouelfadl