Ignore grant only difference in schema compare

Question

I have a project in ssdt and tfs. When I perform a schema compare, I get differences which include objects in which the only difference is a GRANT in the source which does not exist in the imported local schema.

I cannot find an option in schema compare options which will force these to be ignored.

Thanks for any guidance.

Answer 1

You need to disable "Permissions" in the Schema Compare Options as follows:

1. Click the black gear icon at the top of the schema compare file. (See picture)
2. On the Object Types tab find Application-scoped > Permissions and uncheck it.