Default Comparison Options and Filter rules

pcousins

For all our DBs under source control we set the Comparison options to 'Ignore Users' permissions and role memberships', and the filter rules to exclude users. This is because we have different users in different environments.
My question is this: can we set these as the default for SQL Source Code Control when we link a new database to a repository?

DanC

Hi @pcousins

Unfortunately, this isn't possible and the defaults are pre-set in the software behind the scenes.

However, I have done some tests and what you can do is save and copy the ComparisonOptions.xml & Filter.scpf from one of your configured repositories and then place directly into the new repository and pull the changes and it will apply to that database.

Hope this helps!