Default Comparison Options and Filter rules

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?
Tagged:

Answers

  • 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!

    Kind regards

    Dan Calver | Redgate Software
    Have you visited our 
    Help Center?

Sign In or Register to comment.