Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSDT - Apply Different Security per Target Environment Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 4:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 AM
Points: 105, Visits: 923
Hi

Hopefully the title makes my request obvious but just to elaborate. I am using SQL Server Data Tools for a SQL 2012 database and have set up 3 publish.xml files in order to publish the database to 3 different environments.

I want to be able to alter the security that is applied to the DB post deployment depending on the environment I am targetting.

Any pointers on how to do this?

Thanks

Ben
Post #1433116
Posted Thursday, March 21, 2013 5:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 14, 2014 1:34 AM
Points: 105, Visits: 923
I have answered my own question by using a SQLCMD variable and setting it appropriately in publish scripts.
Post #1433725
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse