<p>We currently deploy web applications by creating a database and running SQL scripts through query analyzer.  Then we copy the output from "publish website" and set up that website in IIS.</p>

<p>We have seen websetup in visual studio, but that part seems to be thinly documented.  For example, we are not clear how to ask the user for IP and password of SQL server.  We also tend to get websites deployed this way coming up under folders like <a href="http://example.com/project" rel="noreferrer">http://example.com/project</a>, instead of just <a href="http://example.com" rel="noreferrer">http://example.com</a>.</p>

<p>Then there are issues with AJAX.Net not being installed or some or the other patch not applied.</p>

<p>So far, we have physical access to the servers.  Pretty soon though we are going to be shipping CDROMs.  What is the practical tradeoff between manual intervention and automation?</p>

[{'answer_id': 62864, 'author': 'Gulzar Nazim', 'author_id': 4337, 'author_profile': 'https://Stackoverflow.com/users/4337', 'pm_score': 2, 'selected': False, 'text': '<p>Have you tried using <a href="http://weblogs.asp.net/scottgu/archive/2005/11/06/429723.aspx" rel="nofollow noreferrer">Web Deployment</a> project? There is support for <a href="http://weblogs.asp.net/scottgu/archive/2008/01/28/vs-2008-web-deployment-project-support-released.aspx" rel="nofollow noreferrer">VS 2008</a> also now..</p>\n'}, {'answer_id': 62895, 'author': 'user7239', 'author_id': 7239, 'author_profile': 'https://Stackoverflow.com/users/7239', 'pm_score': 4, 'selected': True, 'text': '<p>Avoid Visual Studio deployment, and automate as much as possible. Web Deployment Projects and NAnt can be your friends! </p>\n\n<p>Briefly, our deployment setup:</p>\n\n<ol>\n<li><p>We use RedGate SQL to script differences between dev and live database.</p></li>\n<li><p>An NAnt build file which calls MSBUILD to build the web deployment project (.wdproj), zips up the resulting compiled web app (along with the SQL change script) and then uploads the zip file to the server. </p></li>\n<li><p>On the server side, there is another NAnt build file which takes the application offline, backs up the database, backs up the website. runs the SQL change script, unzips the new version and brings the app online. </p></li>\n</ol>\n\n<p>Step 3 is usually run "manually" (one double-click), but sometimes scheduled for late at night. You could do exactly the same from a CDROM, or even write a pretty little Windows Forms app as a wrapper. </p>\n\n<p>Quite happy to give details of the NAnt script if you\'re interested.</p>\n'}, {'answer_id': 3302966, 'author': 'Justin', 'author_id': 332026, 'author_profile': 'https://Stackoverflow.com/users/332026', 'pm_score': 0, 'selected': False, 'text': '<p>I deploy mostly ASP.NET apps to Linux servers. Here is my standard workflow:</p>\n\n<ul>\n<li>I use a source code repository (like Subversion)</li>\n<li>On the server, I have a bash script that does the following:\n\n<ul>\n<li>Checks out the latest code</li>\n<li>Does a build (creates the DLLs)</li>\n<li>Filters the files down to the essentials (removes code files for example)</li>\n<li>Backs up the database</li>\n<li>Deploys the files to the web server in a directory named with the current date</li>\n<li>Updates the database if a new schema is included in the deployment</li>\n<li>Makes the new installation the default one so it will be served with the next hit</li>\n</ul></li>\n</ul>\n\n<p>Checkout is done with the command-line version of Subversion and building is done with xbuild (msbuild work-alike from the Mono project). Most of the magic is done in ReleaseIt.</p>\n\n<p>On my dev server I essentially have continuous integration but on the production side I actually SSH into the server and initiate the deployment manually by running the script. My script is cleverly called \'deploy\' so that is what I type at the bash prompt. I am very creative. Not.</p>\n\n<p>In production, I have to type \'deploy\' twice: once to check-out, build, and deploy to a dated directory and once to make that directory the default instance. Since the directories are dated, I can revert to any previous deployment simply by typing \'deploy\' from within the relevant directory.</p>\n\n<p>Initial deployment takes a couple of minutes and reversion to a prior version takes a few seconds.</p>\n\n<p>It has been a nice solution for me and relies only on the three command-line utilities (svn, xbuild, and releaseit), the DB client, SSH, and Bash.</p>\n\n<p>I really need to update the copy of ReleaseIt on CodePlex sometime:</p>\n\n<p><a href="http://releaseit.codeplex.com/" rel="nofollow noreferrer">http://releaseit.codeplex.com/</a></p>\n'}]
['https://Stackoverflow.com/questions/62816', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/6629/']