title: Redgate SQL Source Control: ignoring Database Roles
body: <p>I'm using Redgate Source Control to changetrack a database. I have a testing database from which I commit, and a production database which is the final target.</p>
  <p>I want to have a different Database Role (the setting found of Database-&gt;Security-&gt;Roles-&gt;Database Roles) in the production database because of specific requirements. I have changed one database on my production server, but every time I deploy to the production database, the Database Role resets to the status it was before I changed it (even though the specific role is not synced).</p>
  <p>I found a filter on Comparison Options for user roles and checked the Ignore: &quot;User's permissions and role memberships&quot; and deployed the filter, but the Database role still resets every time I deploy any change to production.
  <a href="https://i.stack.imgur.com/Burw0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Burw0.png" alt="enter image description here" /></a></p>
  <p>Is there a way to ignore Database roles or is there a workaround I could use?</p>
  <p>EDIT:
  Larnu's answer is correct.
  I had a separate issue here which had to do with the role permissions not being defined in the role, but in the schema.sql file. So I had to commit the whole schema to get the role permissions committed.</p>