Hi @zservati
There are 2 things in your post : upgrade and DB change.
To upgrade from 6.7 to 8.9, you need to go through this path : 6.7 → 7.9 ex-LTS → 8.9.6 current LTS.
As mentioned here, please read carefully the notes before upgrading to avoid any surprises
For your DB migration, I encourage you to read this old post that was published when MySQL support went to an end : End of Life of MySQL Support
You will find the requested information.
The tool to be used is mysql-migrator.
Hope this will help,
Have a nice journey through SonarQube versions and happy to see you soon on 8.9.6 LTS!
Carine