• I personally embrace project based deployment methods such as the use of SSDT and dacpacs. I think that this method would prove a challenge in that environment because you'd have to create more than one build of the dacpac and deploy them in stages. The alternative would be to put everything in the pre-scripts but then you lose the value that is gained with that type of project.

    For implementations that aren't doing this and prefer to execute hand-made scripts, I find it a useful tactic.

    Derik Hammer
    @SQLHammer
    www.sqlhammer.com