Code Analysis config to flat file
Code Analysis released in 9.0 is awesome! But I turn off a lot of the rules for day-to-day work. I know not to release production code with "select *" in it... But not all the devs do... so I have to click these rules back on to get Code Analysis to help me when I'm doing review.
Could we have profiles for CA like in Format SQL? Better still, could we have the config of these profiles in flat files? I could version & share different profiles with devs - allowing them to check rules I'm going to check anyway and cutting down on time spent on code review.
We added this feature recently (in SQL Prompt 22.214.171.12438).
Now it is possible to save your settings file in a shared folder for the team to use or switch between different settings files. This is accessible via the Prompt menu : SQL Prompt > Manage Code Analysis Rules….
Let me know if you find it helpful.
Alessandro Alpi commented
I'd really love to get an optional cloud store for redgate settings, too ????
I'll just copy the answer here I got from AlessandroAlpi on the forum:
The rules for Static Code Analysis are stored in `C:\Users\<youruser>\AppData\Roaming\SqlCodeGuard30` as a XML file. The file name is settingsv3.xml.
So you can have two versions and rename them manually if you want to switch.
Definitely needed for Enterprise Standards, Import-Export is a must-have.
PLUS, a "keyword find" wouldn't go amiss as there quite a stack of rules to eye-ball through to get to the one to turn off...
Out of votes, but it would have been +3, not just the one...