Option to run drift script automatically
Our team would like to configure SCA to execute drift scripts automatically on the target database so source control is always used as the source of truth.. We find it a hassle having to run it manually in our multi-tenanted environment. Currently, the drift script must be run manually per environment.
Anonymous
shared this idea
-
AdminKendra
(Admin, Redgate)
commented
Apologies for the delayed notice on this, but this feature has been added to SQL Change Automation. There is now a "DriftHandling" parameter on the Use-DatabaseReleaseArtifact cmdlet.
The default for this is to ignore it (not revert drift), but you can set this to RevertOnly and RevertAndDeploy. More information is here: https://documentation.red-gate.com/sca4/reference/powershell-cmdlets/use-databasereleaseartifact
Thank you for this suggestion!