Is there a way to run your code analysis rules against an existing database?
To help our developers we - as dba's - perform validation against their procedures and database code. The library of rules that is incorporated in SQLPrompt could be a good rule of thumb for the basic stuff of reviewing, so that we can focus on other stuff when validating.
Is it possible to run the rules "engine" of SQLPrompt against an existing database without having to open the code manually?
3
votes
Anonymous
shared this idea
-
Phil Factor
commented
Yes, there is a way of doing this as explained in this article
https://www.red-gate.com/hub/product-learning/sql-change-automation/sql-code-analysis-powershell-deployment-script?topic=sql-code-analysis&product=sql-change-automation