What are the challenges you face when working across database platforms? Take the survey
Options

AZURE Release task, how to Exclude Additional objects?

ManuelSanrepotManuelSanrepot Posts: 3 New member
edited May 21, 2020 3:12PM in SQL Change Automation
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.
Tagged:

Answers

Sign In or Register to comment.