Import external T-SQL issues from Microsoft.Rules.Data.*

Suggest new features
1

It would be nice if the Microsoft.Rules.Data.* StaticCode Analysis File (wich is generated from the msbuild of ad MS SQL Server Dacpac Projekt) would be automatically added to the Sonar like the Roslyn Files for C#.

3

Hi @ArminPrieschl

Thank you for your message.

From what I understand, this is about SQL files?

4

Yes its for SQL Files.
SSDT is a Project Type for SQL Server Dacpac Projects. ( https://visualstudio.microsoft.com/vs/features/ssdt/) => And a static code analysis is included. Comparable to the C # Roslyn files, which are already processed automatically by Sonar.

6

Thanks for confirming, @ArminPrieschl. Do you know in which format the external rules report is stored? Is it using the SARIF format or something else?

Can you create a small sample project where the static code analysis issues are exported in a file, and give us access to it, to examine the format of the file?

Thanks,
Andrei

For reference: Overview of Extensibility for Database Code Analysis Rules

7

There are 2 Files in the bin/Release Folder after Building the Project:
[ProjectName]_StaticCodeAnalysisSucceededFile => A SuccessFile for the Analysis
[ProjectName].StaticCodeAnalysis.Results.xml => an XML File with the results

XML:

image
image1267×475 19.6 KB

Rules:

image
image715×405 12 KB

8

Any News here?

Another Solution could be to add this Mircrosoft Rules to the Sonar T-SQL Ruleset. Is this possible?
THX