Migrate Data from sonarqube instance in mysql to one in postgres

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
  • what are you trying to achieve
  • what have you tried so far to achieve this

There is dev sonarqube instance running with MySQL - 7.9 version LTS

I have another sonarqube instance running in client env but due to some constraints only with postgres DB

how can I migrate all my projects/data from dev sonarqube to one with postgres


Welcome to the community!

To be clear, 7.9 doesn’t run on MySQL, so you might have gotten your versions mixed up. Also, this sounds strikingly like this question:

Although you have given a few more details. Are you colleagues?

At any rate, without an upgrade to Enterprise Edition($$) you’re not going to be able to move these projects from one server to the other. You can however use sonar.projectDate to recreate the projects by analyzing old versions of the code in chronological order.


Thanks Ann for the inputs,