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.
Kind regards,
Dan Bainbridge
Product Support Engineer | Redgate Software
@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.
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.
Sean Quigley | Product Support Engineer | Redgate Software
Answers
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 Bainbridge
Product Support Engineer | Redgate Software
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.
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?