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
Hi,
I am fairly new to Sonar server configuration. Currently we are using Sonar 6.7.7 and MySQL as the database back end. Since both our Sonar version and MySQL is no longer supported I need to upgrade our version and migrate MySQL data to PgSQL. I was able to covert the data to PgSQL using “pgloader” and tested the data using Sonar 6.7.7-Community. But somehow when I run Sonar 8.2, Sonar seems to wipe out my data in PgSQL and it creates new tables. It does not happen when I use Sonar 6.7.7. I would like to seek advise on how can I run latest Sonar Version and also retaining the DB dump I have from MySQL.
By the way I am using Docker for Both Sonar and PgSQL.
I have no experience - either real or by reputation - with pgloader. However, we’ve created a free migrator to get you off of MySQL. I suggest you give it a try and come back to us if you’re still having problems.
Thank you for checking on this. I was able to fix my issue when followed suggestion from “https://stackoverflow.com/questions/58726379/sonarqube-update-6-7-to-7-9-empty-tables” to add schema value in the sonar.jdbc.url configuration for Sonar. After defining the db schema, I was able to access sonar setup and Sonar did the rest of the upgrade.
Additional Step I made is to delete “<Sonar_Home>/data/es*” when I cannot see my projects from the home page. Both steps requires Sonar to restart and apply the changes.