I couldn't find a way to do this with the SQL Compare filters, as it's a project level option. I want to track schema changes, but exclude monitoring the permissions changes, as this is done with a dynamic script and makes a lot of noise in DLM. Any ideas on if this is possible?
Comments
1 comment
-
The IgnoreUsersPermissionsAndRoleMemberships associated with SQL Compare can be set in SQL Source Control as a comparison option. Even though I'm not seeing it explicitly called out in the docs, this excludes schema permissions (in addition to user permissions and role membership.
Add comment
Please sign in to leave a comment.