What are the challenges you face when working across database platforms? Take the survey
Options

Compare Options in Visual Studio SQL Change Automation

Is there a way to use the SQL Compare options in a Visual Studio SQL Change Automation Project? 

The problem I am having is that I have users and groups, which I can exclude using the Filter, however, things like add role members still comes across.   Previously, in DLM, we had SQL options defined in SSMS.

Not finding how to do this in the documentation.

Since our security is going to be different in every environment, this ends up spitting out a lot of changes during a refresh.  I need to make it clean for the development team so they can focus on their actual changes.

Thoughts?
Tagged:

Best Answer

Answers

Sign In or Register to comment.