Migrating SonarQube server from one server to another changed server ID

SonarQube Server / Community Build
1

Hello,

We are in process of migrating SonarQube server from one server (v_7.9.1) to another (v_ 9.9.1) Developer Edition. We also changed our database from PostgreSQL to MSSQL.
We observed our server id got changed.
Can we preserve the same server ID while migrating to new server ?

2

Hi,

Welcome to the community!

Your server id is based in part on the JDBC URL. So switching DB engines will quite naturally change your server ID. Your sales rep should be able to help you out.

 
Ann

3

Hi,

Thanks for the info.
Could you please help us with the document to migrate db from PostgreSQL to MSSQL ?

Regards,
Shravani

4

Hi Shravani,

The DB Copy Tool is available for that.

 
HTH,
Ann

5

Hello ,

We are running on sonar Version 7.9.1 and PostgreSQL 9.5.4 and we want to migrate to sonar version 9.9.1.69595 and MSSQL 2016. What steps should we follow in achieving this ?

We used DB Copy Tool to migrate data but it is giving error because number of tables in source and destination is diferent and also because of schema difference it fails to migrate data.

Regards,
Shravani

6

Hi Shravani,

You should do one thing at a time. Follow the upgrade path to SonarQube 9.9.1 on Postgres, then switch DB engines.

 
HTH,
Ann