i recently tried to upgrade from SonarQube 5.6.1 LTS to 6.0.
I used the Upgrade Guide but i have got an database migration error.
Fail to execute database migration: org.sonar.db.version.v60.CleanUsurperRootComponents com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CS_AS" and "Latin1_General_CS_AS" in the equal to operation.
I'm usings SQL 2014 with SQL_Latin1_General_CP1_CS_AS.
I used for the setup the following guide:
SonarQube Setup Gruide for .Net Users v.1.3
There are 157 columns with the wrong collation "Latin1_General_CS_AS" in the Sonar database.
Regards
Daniel
Option 1: Start with a new and empty database.
Option 2: Restore the SonarQube database and change the database collation using SQL Management Studio (assuming that the database is called SonarQube) before starting the upgrade again:
The result should be Latin1_General_CS_AS. If the query returns SQL_Latin1_General_CP1_CS_AS change the database collation before upgrading to 6.0:
Option 3: (last resort) Change the database collation (see option 2) and change the database manually (using SQL Management Studio). First execute the following query
This will return several lines; for example:
Some columns cannot be changed in this way because the column is used in an index that must be dropped first. For example:
Restart SonarQube and start the upgrade again.