How can I run code analysis on existing database using sql prompt?

• 
  Hi Vsotirov,
  
  Thanks for posting on the Redgate forums.
  
  SQL Prompt works with whatever query you have open within SSMS or Visual Studio. Therefore to get the benefits of SQL Prompt you need to open the query you are working on. Please do let me know if you need any further assistance.

  Dan B March 04, 2019 11:37

  - 0 +
• 
  @Dan B I know how to use it for code I have open in SSMS and Visual Studio and I am already using it. I was trying to run the rules against legacy code my teammates created or integrate it as part of our deployment. We use AzureDevops pipeline for deployment.

  vsotirov March 04, 2019 19:25

  - 0 +
• 
  Unfortunately SQL Prompt can't really work well in a pipeline environment as it currently doesn't have a command line feature available.

  
  

  As you can see from the below roadmap, it's unfortunately the case that SQL Prompt will more than likely not have the command line as a feature for the foreseeable future:
  https://www.red-gate.com/products/sql-development/sql-prompt/roadmap
  
  To be honest, you are probably better off using SQL Code Guard with it's command line feature for the time being.
  

  
  

  https://documentation.red-gate.com/scg/sql-code-guard-3-documentation/using-sql-code-guard-command-line

  
  

  Please note that you won't be able to do formatting with SQL Code Guard and it will require a SQL Toolbelt License in order to use it in an automated setting.
  

  squigley March 05, 2019 00:20

  - 0 +

Add comment

Please sign in to leave a comment.