SSDT - Apply Different Security per Target Environment

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2012 » SQL 2012 - General » SSDT - Apply Different Security per Target...

SSDT - Apply Different Security per Target Environment

Rate Topic

Display Mode

Topic Options

Author

Message

benlatham

Posted Wednesday, March 20, 2013 4:19 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:10 AM
Points: 79, Visits: 874

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

benlatham

Posted Thursday, March 21, 2013 5:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:10 AM
Points: 79, Visits: 874

I have answered my own question by using a SQLCMD variable and setting it appropriately in publish scripts.

Post #1433725

« Prev Topic | Next Topic »

Permissions