Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines . It is not currently accepting answers.
We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.
Closed 5 hours ago.
Improve this question
Is there something out there like an extension for Azure Devops that will do a SQL syntax check? We have an on-perm SQL Server and before I run a pipeline, I want to do a SQL syntax check to be applied to our pull request.
I want to make make a gate or something that will validate T-SQL scripts before I build and release a pipeline onto our on-perm servers.
Thanks.
2条答案
按热度按时间axkjgtzd1#
SQL Prompt: This is a tool from Redgate that provides SQL code formatting and syntax highlighting, as well as suggestions for improving SQL code. While it does not provide full syntax checking, it can help catch common mistakes and improve code quality. SQL Prompt can be integrated with Azure DevOps as an extension, and you can use it as part of your pull request review process.
ovfsdjhp2#
Are those scripts creating SQL objects or inserting data? If they are doing both then I suggest maintaining them in SSDT VS SQL project, which can be built using VS Build command and generates a DACPAC zip output, which can be used with SQLpackage.exe to publish.
More reading can be done here https://visualstudio.microsoft.com/vs/features/ssdt/
https://learn.microsoft.com/en-us/sql/ssdt/how-to-create-a-new-database-project
https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage