Consolidate SonarQube Databases

SonarQube Server / Community Build
1

We have two SonarQube instances, both are Community Edition Version 10.1 (build 73491).
SonarQube deployed: zip
We would like to consolidate both instances into a single one.
I tried to use the SonarQube DB Copy Tool to copy one instance data into the other Database (both are Oracle Databases.
The copy was succesful, but I figured out that during the copy, the tool is truncating the tables on the destination.
My questions are:

  1. Is there a way to use the DB Copy Tool with a parameter to populate / add the data into the destination instead of truncating?
  2. If #1 is not possible, are there any expirience or best parctice to achive our goal?
2

Hey there.

It’s not possible to merge two separate SonarQube databases without using Project Move (and here, project import is only available in the Enterprise Edition and above). The DB Copy Tool is only for moving entire databases from one database platform to another.

If you’re staying on Community Edition, you will need to choose which SonarQube instance to move forward with, and begin analyzing the projects on your old instance with the new instance.