Database:MySQL , version:5.6.35 ,
Trying to migrate the old DB to new DB.
We are given .sql script of old SonarQube DB , which we are trying to restore to new DB.
Above mentioned versions are of new SonarQube and DB.We have no information on the old version of SonarQube. We are unable to restore the old data because of schema differences.
SonarQube Schema differences are,
1)analysis_properties table is present in old
execution_count is the extra column in the old schema
3)active_rule_parameters data is more in old schema.
Kindly suggest the way out to restore the old DB with old schema to new one as we have to see the analysis trend.
I am manually comparing the two schema and see above differences.