SonarQube migration from SQL server 2012 to 2016


(Rolex-g7) #1

Hi everyone,

I am currently running SonarQube 6.3.1 on a Linux host today connected to SQL server 2012 database. However when now planning to upgrade to the latest version 7.4, I need to migrate to SQL server 2016.

I used the following steps to do that by first copying my database on SQL 2012 to SQL 2016, then performing a upgrade and connect to the 2016 instance. I am not sure if this is the right procedure, however currently I am not able to start the application and I am recieving this error in the web.log:

`2018.11.27 17:06:24 ERROR web[][o.s.s.p.Platform] Web server startup failed: Current version is too old. Please upgrade to Long Term Support version firstly.`

Awaiting feedback and suggestions on how to counter this issue.

Thanks a lot.


(Colin Mueller) #2

Greetings.

I would spend some more time with our Upgrade Documentation

Upgrading across multiple, non-LTS versions is handled automatically. However, if in your migration path you have an LTS version, you must first migrate to this LTS and then migrate to your target version.

You will need to upgrade to 6.7.6 prior to upgrading to 7.4.

Colin


(Rolex-g7) #3

Thanks for your quick feedback @ColinHMueller. When it comes to database migration is the steps I mentioned correct? When upgrading fra 6.3.1 to 6.7.6, I will first copy my DB from 2012 to 2016 and then perform the upgrade with the configuration files pointing to the 2016 DB.

Please let me know.


(Colin Mueller) #4

Rolex,

Sounds fine to me (naturally this should all be tested in a sub-production environment first).

I am assuming this is a Community Edition install so nothing to worry about so far as Server ID or license keys.

Colin


(Rolex-g7) #5

@ColinHMueller - That correct. This in a test environment first. I will get back to you as soon I have confirmed it.

Thanks a lot.