I have a database project in visual studio (2008) that I am using to keep my database structure in a version control system (Git). I use the data schema compare tool in VS to maintain this database project. The issue that I'm encountering is that I keep losing my permissions for new objects.
So how do I:
- Capture these permissions using the schema compare tool.
- Apply these permissions to a server using the schema compare tool.