How to analyse MS Sql database project

SonarCloud
, ,
1

ALM used: Azure DevOps
CI system used: Azure DevOps
Languages of the repository: C#, TypeScript, T-SQL

Have set up our project in sonar cloud and happily seeing it run against our client app (Angular, typescript) and aspnet core (C#) api.

Within our solution we have a MS SQL database project. I notice in the bindings for SonarLint are not present in the database project but in the other projects. The SQL project folder is not visible inside SonarCloud’s ‘Code’ view and there is no analysis against the database project SQL files.

Can you please provide guidance as to how to configure a MS SQL database project in SonarCloud.

2

Hi,

Is the question about analyzing the files in SonarCloud or SonarLint?

And what flavor of SQL are the files? T-SQL? PL/SQL? Something else?

 
Ann

3

Question is both but primarily with SonarCloud.

We have a solution which contains a Microsoft SQL project. However the contents of the folder are not getting analysed. I’m also not seeing any of the content of the SQL project within the ‘code’ view of the project inside Sonarcloud.

4

Hi,

What are the file extensions - per language - of your SQL files? Can can you share your analysis log?

The analysis / scanner log is what’s output from the analysis command. Hopefully, the log you provide - redacted as necessary - will include that command as well.

This guide will help you find them.

 
Ann