Find Invalid Objects feature for CI/CD on command line
maxschafintact
Posts: 8 New member
in SQL Prompt
Hi,
we experimented with a SQL Source Control project (using Flyway Desktop) and we CI/CD this to target db (production) with powershell commandlets (SQL Change automation). After devs commit to repo, we run a CI pipeline to validate db structure changes calling Invoke-DatabaseBuild .
we recognized that Invoke-DatabaseBuild is not as good as SQL Prompt Find Invalid Objects feature to find issues. So we are asking ourselves if we can use the SQL Prompt feature on command line?
BR
we experimented with a SQL Source Control project (using Flyway Desktop) and we CI/CD this to target db (production) with powershell commandlets (SQL Change automation). After devs commit to repo, we run a CI pipeline to validate db structure changes calling Invoke-DatabaseBuild .
we recognized that Invoke-DatabaseBuild is not as good as SQL Prompt Find Invalid Objects feature to find issues. So we are asking ourselves if we can use the SQL Prompt feature on command line?
BR
Tagged:
Answers
Hello maxschafintact,
I'm sorry to say this functionality isn't one of the features of the Prompt CLI.
You could suggest it on the dedicated customer feature request forum to see if there might be more members of the community interested in the same.
https://redgate.uservoice.com
thanks for your answer.