SonarQube Embed Database configuration with Azure SQL Database

SonarQube Server / Community Build
1

Hello,

SonarQube Developer Edition is running as a Contain instance in Azure and our SQL DB are in Azure as well. We use SSMS to access the the Azure Server Database. Is there any instruction on how to embed a database with this setup?

Thanks

2

Hi,

Could you expand on “embed”? What you’re after isn’t clear to me.

 
Ann

3

Hi

Thanks for responding. I’m trying to remove the H2 Database and embed our own DB. Based on the message below shouldn’t use the H2 DB in production. Based on our configuration are there any instructions on how that can be done.

image
image1274×117 9.32 KB

4

Hi,

Okay! So you don’t need to “embed” your own database. You just need to point to a database outside of SonarQube. To do that you’ll edit the $SONARQUBE-HOME/conf/sonar.properties file. The docs will get you started.

 
HTH,
Ann

5

That’s where I’m confused. How can I access that file if SQ is in a container instance and not download on to my computer?

6

Hi,

I guess you’ll do it via envvars?

 
Ann

7

yea, I think I’m going to have to terminate the container instance and redo it with the necessary environment variables which is what I was I afraid of. It doesn’t look like you can add env vars to an already running instances in azure. :frowning_face:

Thanks

8

To be fair, even if it weren’t in a container you’d have to restart to change the DB.

 
Ann