Ability to run Code Analysis against whole DB
With the deprecation of SQL Code Guard and it's replacement by Code Analysis there is one feature that we heavily used that is now no longer there, and that is the ability to run SQL Code Guard against the whole DB not just the query on the screen.
This allowed us to investigate new DBs that we'd inherited to see what sort of cleanup we might be looking at as well as giving us the ability to see if anything had snuck in to our existing DBs without going file by file.
I know there are other tools (like SQL Enlight) out there that are capable of doing this sort of thing, but I'd prefer to stick with RedGate.
-
@nihar - Please consider using the code analysis command line in the meantime. https://documentation.red-gate.com/scg/sql-code-analysis-documentation/code-analysis-for-sql-server-command-line
-
Nihar Bhalerao commented
We would love to see this feature as well.
-
Anonymous commented
I totally agree with this. There doesn't seem to be any way of doing this with the new SQL Prompt analysis. Even the code analysis in SQL Change Automation, while welcome, only seems to analyse the changed objects so it's no use for finding issues in a legacy database