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:
- Capture these permissions while using schema compare tool.
- 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