We are trying to capture the Code Coverage metrics in SonarQube for SQL Projects but it doesn’t seem to be working. We are able to scan the SQL Project repository and get metrics around Bugs, Code Smells, Duplications but not Code Coverage. We are using tSQLt for writing Unit Tests for our SQL Pro…

Any help you can give would be greatly appreciated.

We have used MSTest as testing framework for writing all Stored Procedures unit test case for TSQL projects. Dynamic Code Coverage Tools > CodeCoverage.exe : Should the sonar cloud will cover the code coverage for all Stored Procedures? Its showing now 0.0% coverage for all Stored Procedures thoug…

Below steps followed as part of the code coverage Azure/Sonar configuration. Used task with standalone scanner to run the analysis Task to generate .trx (test result) file and coverage file Convert Coverage File into .coverageXML using CodeCoverage.exe tool Task to upload the .coverageXML results …

[image] supravat.samanta: We are using tSQLt for writing Unit Tests for our SQL Projects. We have generated the Code Coverage file using SQLCover. However SonarQube cant read this coverage file and generate the code coverage metrics. Can you please clarify what you mean by “cant read this cov…

Hello @janos Thanks for reaching us to provide quick guidance. We are doing the below process Implementing code coverage for Microsoft SQL Server Database Project How we are doing? “SQL Server Database” Project which contains stored procedure inside “Transact-SQL” script file “MSTest Unit Test”…

In order to see test coverage data on SonarCloud, the following is needed: Test coverage report files, in some format supported by SonarCloud. The scanner needs to find the report files to import them. Usually it can find the report files at typical locations, when in doubt, it’s best to specify t…

Thanks @janos for your quick help. We will explore all the possible ways you mentioned and will comeback with our outcome soon.

Code Coverage 0.0% for TSQL Projects(Contains Stored Procedures, Tables, Scripts etc)

SonarQube Cloud

Topic		Replies	Views
Code Coverage Metrics for SQL Projects in SonarQube SonarQube Server / Community Build tsql , sonarqube , coverage	1	2850	August 15, 2019
Code coverage report for TSQLT on SonarQube not showing up SonarQube Server / Community Build tsql , sonarqube , unit-test	5	1933	June 25, 2022
Does sonar cloud code coverage of Transact-SQL script file cover as a whole or Individual sql statements inside the file? SonarQube Cloud tsql , scanner , coverage , mssql	3	1388	July 20, 2021
Import TSQL code coverage in SQ SonarQube Server / Community Build tsql , sonarqube	1	928	December 10, 2021
Code coverage of SQL unit testing with tSQLt tool and integrating in Sonarqube dashboard SonarQube Server / Community Build tsql	3	1903	June 29, 2022

Code Coverage 0.0% for TSQL Projects(Contains Stored Procedures, Tables, Scripts etc)

Related topics