Passing SkipPreUpdateSchemaCheck to Azure Devops "Deploy database changes from a release artifact"

Bugmeister

Hi,

Is there any way to pass the SkipPreUpdateSchemaCheck to the redgate Azure Devops "Deploy database changes from a release artifact"?  It has a checkbox for "Skip post update schema check" but not for the pre-schema check.

Thanks
Peter

Sergio R

Hi Peter,

Currently, it is not possible to do that on the add-on.

You can do this in Azure DevOps by using a Powershell step instead of the add-on.
https://documentation.red-gate.com/sca/reference/powershell-cmdlets/use-databasereleaseartifact

If you wish, you can also suggest this as an enhancement in the SQL Change Automation Uservoice forum:
https://redgate.uservoice.com/forums/267000-sql-change-automation

Kind Regards,

Bugmeister

OK thanks, I'll have an attempt to change it to be a powershell script (I had been using Powershell when testing).  Only challenge I see is working out the agent paths to use, but I'm sure that's documented somewhere, just haven't gone to that level in Azure Devops as yet.