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

SQL Change Automation release task in AzureDevOps

I have a build artifact in azure (from a sql source control repository) and I'd like to apply this artifact to a database.
I'm using the "SQL Change Automation Release" task available in AzureDevOps.
In the task options, I set the "SQL compare options" textbox with "IgnoreCollations,IgnoreUserProperties,IgnoreUsersPermissionsAndRoleMemberships, IgnoreSchemaObjectAuthorization,IgnoreExtendedProperties,IgnorePermissions".
When the release pipeline runs, everything works until the generated script tries to drop users and it fails (i want to exclude Users info).

How can I ignore users?

Thanks.

Answers

Sign In or Register to comment.