How do I share my list of enabled Code Analysis rules?
Jacco
Posts: 11 Bronze 1
in SQL Prompt
I've analyzed the rules in Code Analysis and disabled a bit less than half of them. How can I share this list with my development team so they can easily import it instead of manually having to disable rules?
Tagged:
Best Answer
-
AlessandroAlpi Posts: 91 Gold 2Hi @Jacco,
the rules are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. You can write a PowerShell in order to copy that file in a shared environment (a source control or else a cloud storage, like Google drive/One drive/Dropbox). Then, everyone must copy that file in its `C:\Users\<itsuser>\AppData\Roaming\SqlCodeGuard30` folder.
I didn't find any "default location" for that XML file. I'd like to change it to set the shared folder, but I couldn't find anything about this setting.
For the moment, we're getting the XML setting file and copying it on a git repo. Then, every team member executes a PoSh script in order to put the file into its user folder.Alessandro Alpi
CTO @ Engage IT Services s.r.l.
Database Administrator and Team Leader
Microsoft MVP - Data Platform
Staff member of getlatestversion.it community
personal website | blog
Answers
It would definitely be useful to be able to set a path for the file. I see that there is already a suggestion in this direction on UserVoice, so I'll add my vote and comment to that.