How can we help you today? How can we help you today?

AZURE Release task, how to Exclude Additional objects?

I have an Azure Devops Release Task that uses an artifact generated from a SQL Source Control Project.
I'd like to exclude all additional objects (objects that only exists in target database and not in source).
By default, the Release task drops all these objects and I dont wan't to lose data in production environment.   

How can I do this? 

I Know I can use filters to exclude specific names, but i dont know in advance these objects (could be one, twenty, none....)

Thanks.
ManuelSanrepot
0

Comments

1 comment

Sort by
  • Sergio R
    This is possible if you use a Powershell script directly: you just need to use the -IgnoreAdditional parameter in the New-DatabaseReleaseArtifact when creating the release.

    This feature is not available in the Azure DevOps addon.
    If you wish to you can suggest this as an enhancement on the SQL Change Automation uservoice channel:
    https://redgate.uservoice.com/forums/267000-sql-change-automation

    Sergio R
    0

Add comment

Please sign in to leave a comment.