How can I create SQL Server Users based on build configuration using SSDT?

Question

I am new to SSDT so hopefully this is an easy one. I would like to script different users based on build configuration in my database project. Is the only way to accomplish that by using SQLCMD variables and Post Deployment Scripts?

As of now I am just setting the build action on the user to none or build depending on which user I want to be scripted. — Mike
– Mike, Commented Nov 14, 2013 at 15:38

Peter Schott · Accepted Answer · 2013-11-14 16:41:29Z

1

Mike, as far as I know the only easy-ish way to do this is with SQLCMD variables and post-deploy scripts. You could probably code something that would parse the generated script and tweak it for each environment, but using the post-deploy scripts will be far easier in the long run.

I've blogged about this, building on Jamie Thomson's idea. http://schottsql.blogspot.com/2013/05/ssdt-setting-different-permissions-per.html

answered Nov 14, 2013 at 16:41

Peter Schott

4,73625 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I create SQL Server Users based on build configuration using SSDT?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related