Want to upgrade my sonar 6.7 CE to latest one. currently I am using mysql database

SonarQube
1

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

I am using sonarqube 6,7 want to upgrade with latest version now. How can I migrate from MySQL to PostgreSQL database. need proper document if possible.

2

Good morning, Lokesh, so there is a lot to unpack here, as you may know, you are using a SQ release from October 2017. In some cases, it may be easier to simply set up SQ 9.7, and then start scanning… your upgrade path is SQ 6.7 > SQ 7.0 > SQ 8.9 > SQ 9.7.x which is some effort. upgrade links below. Additionally, and also on this forum converting the MySql DB should probably be a first item on your effort list (if you do not choose to simply start fresh) GitHub - SonarSource/mysql-migrator: Command line tool to migrate MySQL database of SonarQube 6.7-7.8 to non-MySQL and the upgrade section here: Upgrade guide downloads here Download | SonarQube and go down near bottom of page for “historical releases”. best of luck

3

Thanks for your replay. I have gone through these all the documents but I have confusion.

  1. I am using mysql database for current SonarQube & that mysql is not installed in that sonar instance
  2. Now I am going to install PostgreSQL database in that local machine so How can i migrate the database I didnt understand that.

So any document or you can guide me how can I perform this task to upgrade my sonar version with database migration.

Thanks

4

Good morning, I am not a technical resource, and thus my answers are more high level for guidance only. in the link above, this allows you to migrate from MySql to Postgres, as we dropped support for mysql in SonarQube a long time ago. the other links are the process once you are running, to upgrade through the various release versions., and again, you are a ways behind and this might get painful. My only other thought was, put aside your SQ 6.7 install, and set up a new SQ 9.7 install and scan projects. Yes you would lose history in part in the new set up, but (a) you would have this history if needed in the old instance and (b) you would not have to do essentially 3 upgrades - make sense?