Need to migrate MySQl on SQ 7.7(non LTS) to MSSQL on SQ 7.9.1(LTS)

SonarSource / mysql-migrator

Command line tool to migrate MySQL database of SonarQube 6.7-7.8 to non-MySQL

39 stars 11 forks source link

Need to migrate MySQl on SQ 7.7(non LTS) to MSSQL on SQ 7.9.1(LTS) #44

Open amitkumar2283 opened 5 years ago

amitkumar2283 commented 5 years ago

Current setup: SQ: 7.7 DB : MySQL

Desired Setup: SQ: 7.9 (or 7.9.1) DB: MS-SQL

What I did: I started the Desired SQ instance and initiated the DB on MSSQL. now while migrating the DB from Current Setup to Desired setup Problem faced: I get the below error Versions in source and target database don't match: 2612 != 2804

Did I miss an upgrade path?

zeyangli commented 5 years ago

Hello, this tool is no problem, it works well. This problem is because you can not directly upgrade, you should first run a version of the same version of sonar using the postgresql database, and then complete the database migration, and finally complete the version upgrade. I just completed the upgrade experiment yesterday. Please refer to my article. https://github.com/zeyangli/SonarQube-docs/blob/master/05-SonarQube%E6%A8%A1%E6%8B%9F%E5%8D%87%E7%BA%A7.md