Hi
We’ve deployed Sonarqube 7.7 community version in Azure app service with an Azure SQL database. Now I’ve created a new environment in Azure app service with a new Azure SQL database, and it’s operating perfectly. Now I’d like to move data from the old Azure database to the new Azure database. However, I am unable to do so since Azure requires an empty database. So, could somebody give me some pointers? Actually, my goal is to upgrade/migrate existing data from Sonarqube 7.7 azure app service to Sonarqube 9.0 azure app service.
Hi,
Welcome to the community!
You don’t need a new database to upgrade SonarQube. Just point your new SonarQube instance at the existing database and everything should go smoothly. The docs should help.
Ann
We had an old environment in Azure app service with Sonarqube 7.7 community edition connected to an Azure SQL database. Now I’ve set up a new Azure environment with a web app service and an Azure SQL database, and it’s working great. Now I want to transfer data from the old Azure database to the new Azure database. However, I am unable to do so because Microsoft Azure requires that the database schema be empty before it can be imported. I had tried sync between both databases it’s also failed to resolve the issue. So, could somebody share their expertise with me in order to help me solve the problem? My goal is to deploy Sonarqube 9.0 community version to the Azure web app service using a SQL database. Then want to import the old database/data from the existing environment to the new environment. Please feel free to ask me if my explanation is unclear.
Hi
Thanks for the response but when I do that it shows a CGI error and the application does not start.
Hi,
Then that’s what we need to figure out, not how to copy your DB. 
What do your server logs say?
Ann