Sonarqube data migration from community to developer edition

Must-share information (formatted with Markdown):

  • which versions are you using (SonarQube) sonarqube-9.0.1.46107
  • what are you trying to achieve: we have developer edition and want project old data from community edition.
  • what have you tried so far to achieve this: we have restored SQL backup data from community edition to Developer edition. but data is not reflecting. can you guide me how I can achieve this?

Hey there.

Moving from Community Edition to Developer Edition is as simple as starting up a Developer Edition instance up against your database (or a copy of your database).

If the data isn’t appearing in the UI – I would suggest trashing your Elasticsearch index on your Developer Edition instance (removing /data/es7 and restarting).

Thanks Colin…
“we have deleted index and still not appearing”… here are log files etc.
Please suggest what next steps to be done.

ce.log (1.2 KB)
es.log (18.5 KB)
sonar.20211117.log (9.7 KB)
web.log (23.1 KB)

Hey there.

I would expect that this database:

jdbc:sqlserver://localhost:1433;databaseName=Sonar

Does not actually contain any of the backed up data, just a fresh schema.

2021.11.17 09:23:24 INFO web[o.s.s.i.i.AsyncIssueIndexingImpl] 0 branch found in need of issue sync.

I would suggest you make sure that the database specified actually has some data in its tables (issues, for example).

Hi again,
I restored backup again with data, however it is not showing projects…access.log (32.1 KB)
ce.log (903 Bytes)
es.log (4.4 KB)
sonar.20211117.log (4.0 KB)
web.log (19.0 KB)
Please suggest …