Synchronizing staging server

Must-share information (formatted with Markdown):

  • SonarQube Server 2025.1.4
  • how is SonarQube deployed: zip

We have a production and a staging server with Enterprise license running the same SonarQube versions.

The databases have been created on each server individually (i guess they have different DB ids now).

Is it possible to synchronize the project data without invalidating the license?

How can i do this? Should i delete the table on the staging and restore it with the backup from the productive with pg_dump, pg_restore. Or should i only delete the contents of the tables?

I’ve found the documentation on License administration | SonarQube Server 2025.1 LTA | Sonar Documentation but I’m not sure what you mean with “empty the staging database”.

Thank you,

Andreas

Hi Andreas,

As I read this, you should be able to just overlay the old staging DB with the new content. The biggest part of the server ID is the JDBC URL. Since that won’t change, you should be still able to use your existing license key. But if you have a problem with it, just ping your sales contact & they’ll be happy to get you a new key.

 
HTH,
Ann