I've got a database project in visual studio (2008) that i'm using to help keep my database structure inside a version control system (Git); I make use of the data schema compare tool in Versus to keep this database project. The problem that I am experiencing is the fact that I keep losing my permissions for brand new objects.

So how do you:

  1. Capture these permissions while using schema compare tool.
  2. Apply these permissions to some server while using schema compare tool.

The simplest approach to capture and apply the permissions that I've discovered is to enter tools -> options -> database tools -> schema compare and uncheck the ignore permissions checkbox. Then run the schema comparision and apply updates.

Note: This will update every object with permissions inside your schema. I've been taking the permission once i sync my schema changes after which resetting the ignore permissions checkbox