Can our TeamCity server invoke SQL Prompt code analysis rules as part of a TeamCity build check?

Whilst its great that SQL Prompt can be used to highlight SQL code smells in a manual code review, I am hoping that there is scope to include the same rules as part of automated continuous integration process also.

I know that a command line feature of SQL Prompt is on the roadmap, which I imagine would work well for TeamCity integration in this manner. With the current version is there any way this could be achieved?

Nikos 6 years ago

Comments

5 comments

It looks like I could use SQL Code Guard for what i want (command line called by powershell).
https://www.red-gate.com/hub/product-learning/sql-change-automation/sql-code-analysis-powershell-deployment-script (from June 2018)
But SQL Prompt has to be the long term solution, if not the current one.

Nikos 6 years ago

0
Thanks for your inquiry with SQL Prompt.
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.

squigley 6 years ago

0
squigley said:

Thanks for your inquiry with SQL Prompt.
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.

Thanks for the reply squigley, much appreciated!
Am i right to assume that there is no current method for me to call SQL Prompts code inspection logic, from within TeamCity?

Nikos 6 years ago

0
That is correct. This is due to there being no command line functionality within SQL Prompt at the present time.
If you're looking for code analysis, you can use the SQL Code Guard command line for this -
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 like TeamCity.

squigley 6 years ago

0
Again, thank you for your straight and unambiguous answer. Much appreciated.

squigley said:

That is correct. This is due to there being no command line functionality within SQL Prompt at the present time.

If you're looking for code analysis, you can use the SQL Code Guard command line for this -
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 like TeamCity.

Nikos 6 years ago

0