Compare Options in Visual Studio SQL Change Automation
davejhahn
Posts: 15 Bronze 2
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?
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
-
Greg_Smulko
Posts: 41 Silver 1
You need to edit your sqlproj file and set the options manually. For more detailed guidance and additional information please see the documentation: Configuring comparison & script generation options.Greg Smulko | Technical Architect for SQL Monitor | Redgate Software
Answers