At the project I am looking at now there is a _Publish folder with a series of .xml files for the series of environments to publish to. You may double-click on one of them in the Solution Explorer and get a "Publish Database" dialog box. Herein, you may make global variables for the environment such as the user in active directory who will interact with the database. "Advanced..." has a bunch of checkboxes. It might be wise to check "Block incremental deployment if data loss might occur" to prevent a Little Bobby Tables SNAFU. The _Scripts folder has a Script.PostDeployment.sql script which runs after everything else runs!
No comments:
Post a Comment