Post reply

SSDT - Apply Different Security per Target Environment

  • March 20, 2013 at 4:19 am

    #271803

    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

  • March 21, 2013 at 5:18 am

    #1599325

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply