# Upgrading to Sonarqube 6.7.2 to 8.1 **URL:** \ **Category:** SonarQube Server / Community Build\ **Tags:** mysql, postgres, sonarqube\ **Created:** [January 30, 2020, 7:42am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422 "2020-01-30T07:42:32Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [January 30, 2020, 7:42am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/1 "2020-01-30T07:42:32Z")
**SonarQube Details:** Current Version of SonarQube: 6.7.2.37468 Machine Details: AWS ec2. 2vCPU, 4 GB Ram. DB: mysql **Background** - I’ve been using this sonarqube for more than 2 years now and have a licence for 1M loc (Code base is hardly 175kloc). I had never updated to 7.x and above since it required Postgres or Oracle DB and I wanted it on mysql for some reason. Now, that my licence is about to get over and I read that, support for 6.x will be over soon. So, I need to upgrade to 7.9.2 LTS or 8.1. I prefer 8.1 since it supports Gitlab pipelines and merge request comments. **Problem:** 1. DB migration: How easy it is to migrate data from Mysql to Postgres? 2. Which DB is desired? Postgres or Oracle? and Why? 3. What is the DB requirement? (I’ve licence for 1M but code base is hardly 175kloc) 4. What is the right way of upgrading? (I’m sure upgrading from 6.7.2 to 8.1 will not work. I will have to upgrade several times.) 5. Last but not the least: Does 8.1 supports Mysql db? In documents, it says so. Ref: [https://docs.sonarqube.org/latest/requirements/requirements/](https://docs.sonarqube.org/latest/requirements/requirements/) ---
**Author:** ![Antoine](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/antoine/32/77940_2.png) [@Antoine](https://community.sonarsource.com/u/Antoine)\ **Post date:** [January 30, 2020, 5:34pm UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/2 "2020-01-30T17:34:15Z")
Hello @Vighnesh_Pai > [@](#): > > - DB migration: How easy it is to migrate data from Mysql to Postgres? Straightforward with the help of [mysql-migrator](https://github.com/SonarSource/mysql-migrator) > [@](#): > > - Which DB is desired? Postgres or Oracle? and Why? That’s purely your choice. We do run internally on Postgres but our testing chain is exhaustive for Oracle and SQLServer as well. > [@](#): > > - What is the DB requirement? (I’ve licence for 1M but code base is hardly 175kloc) I don’t get the question. There is no link between the DB and the license allowance. Generally speaking, requirements are on the [doc](https://docs.sonarqube.org/latest/requirements/requirements/). > [@](#): > > - What is the right way of upgrading? (I’m sure upgrading from 6.7.2 to 8.1 will not work. I will have to upgrade several times.) Your guess is good. Check out the [Upgrade guide](https://docs.sonarqube.org/latest/setup/upgrading/), there’s everything you need. I suggest to proceed accordingly: 6.7.2 \> 6.7.7 \> 7.9.2 \> 8.1 > [@](#): > > - Last but not the least: Does 8.1 supports Mysql db? In documents, it says so. > Ref: [https://docs.sonarqube.org/latest/requirements/requirements/](https://docs.sonarqube.org/latest/requirements/requirements/) Where do you see a mention of MySQL in this page? MySQL is no longer supported, since 7.9 if I remember correctly. I hope this helps. Antoine ---
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [February 4, 2020, 5:51am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/3 "2020-02-04T05:51:54Z")
> Where do you see a mention of MySQL in this page? MySQL is no longer supported, since 7.9 if I remember correctly. If you go to the Database section of the doc [Prerequisites and overview](https://docs.sonarqube.org/latest/requirements/requirements/#header-3) it is mentioned. ---
**Author:** ![Carine\_Bayon](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/carine_bayon/32/3223_2.png) [@Carine\_Bayon](https://community.sonarsource.com/u/Carine_Bayon)\ **Post date:** [February 4, 2020, 6:47am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/4 "2020-02-04T06:47:35Z")
Hi @Vighnesh_Pai, The link you’ve sent is the correct one to check the DB requirements, and you’ll see that we recommend Oracle, Postgres or MSSQL. There is no mention of MySQL, above 7.9 LTS + version of SQ. Indeed, we deprecated MySQL Support in 7.8 and dropped it in 7.9, as mentioned here: [End of Life of MySQL Support](https://community.sonarsource.com/t/end-of-life-of-mysql-support/8667/17) Carine ---
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [February 4, 2020, 9:17am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/5 "2020-02-04T09:17:58Z")
Thank for clarification! In hurry I misread MSSQL 🙈 ---
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [February 4, 2020, 10:16am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/6 "2020-02-04T10:16:28Z")
Hey I needed one more help on if there are any scripts that is provided by or guide on how to migrate from mysql to Postgres? I’m having a hard time with it. ---
**Author:** ![Carine\_Bayon](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/carine_bayon/32/3223_2.png) [@Carine\_Bayon](https://community.sonarsource.com/u/Carine_Bayon)\ **Post date:** [February 4, 2020, 10:20am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/7 "2020-02-04T10:20:03Z")
Hi, > [@Vighnesh\_Pai](#): > > Hey I needed one more help on if there are any scripts that is provided by or guide on how to migrate from mysql to Postgres? I’m having a hard time with it. My colleague Antoine already sent you the link to the migration tool: > - DB migration: How easy it is to migrate data from Mysql to Postgres? > Straightforward with the help of [mysql-migrator](https://github.com/SonarSource/mysql-migrator) If you have any issues using that tool, please open a new topic on the forum (and I would recommend to check on the forum if the issue hasn’t already been raised by other users doing that migration). Thanks, Carine ---
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [February 4, 2020, 10:21am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/8 "2020-02-04T10:21:49Z")
I wonder how u deal with guys like me 🙈 Having a rough day! Anyways, Thanks for the help. ---
**Author:** ![Vighnesh\_Pai](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/vighnesh_pai/32/5884_2.png) [@Vighnesh\_Pai](https://community.sonarsource.com/u/Vighnesh_Pai)\ **Post date:** [February 4, 2020, 1:46pm UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/9 "2020-02-04T13:46:41Z")
> I don’t get the question. There is no link between the DB and the license allowance. Generally speaking, requirements are on the [doc](https://docs.sonarqube.org/latest/requirements/requirements/) In the docs, it says Postgres 10, 9.3-9.6. My RDS Postgres is 11.5 will it not work? ---
**Author:** ![Antoine](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/antoine/32/77940_2.png) [@Antoine](https://community.sonarsource.com/u/Antoine)\ **Post date:** [February 5, 2020, 8:49am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/10 "2020-02-05T08:49:24Z")
Well, we can’t really say. When the docs says that we support it, it’s because we made tests on it. We didn’t on Postgres 11.x. So you can try, but at your own risk. ---
**Author:** ![pierreguillot](https://dub1.discourse-cdn.com/sonarsource/user_avatar/community.sonarsource.com/pierreguillot/32/46022_2.png) [@pierreguillot](https://community.sonarsource.com/u/pierreguillot)\ **Post date:** [February 5, 2020, 9:33am UTC](https://community.sonarsource.com/t/upgrading-to-sonarqube-6-7-2-to-8-1/19422/11 "2020-02-05T09:33:49Z")
PostgreSQL 11 and 12 will be officially supported with the next release of SonarQube `8.2`. See [https://jira.sonarsource.com/browse/SONAR-12865](https://jira.sonarsource.com/browse/SONAR-12865)