title: One click deployment using TFS Build 2010
body: <p>Let me start with my website architecture I have 2 web servers (staff), 2 web servers (external user), 2 App Servers (wcf) and database server. I have more then 5 environments (which will have there corresponding configuration). </p>
  
  <p>Using Team Build 2010 I am generating packages in the shared folder. This doesn't include database incremental script (schema changes from the last build).</p>
  
  <p>Currently I taking these packages to the remote servers and deploying them using MSBUILD. </p>
  
  <p>Now I need </p>
  
  <ol>
  <li><p>One click deployment approach for this architecture. (an idea)</p></li>
  <li><p>MSBUILD commands that I could use (if possible point me to the complete list)</p></li>
  <li><p>How to generate incremental database script and way to update the database as part of automation (I have Database project in my solution currently I am doing a schema compare after each build)</p></li>
  </ol>
  
  <p>Mostly I think BuildProcesstemplate.xaml has to be edited. Guide in this approach as well. </p>
  
  <p>Things i referred (not helpful in my case)</p>
  
  <ol>
  <li>PDC 09 talk by Vishal R. Joshi</li>
  <li>Continuous deployment with TFS 2010 Build Agent (Hakan Forss blog)</li>
  <li>Web Deployment Made Awesome: If You're Using XCopy, You're Doing It Wrong (Scott Hanselman).</li>
  </ol>
  
  <p>Most of googling and Stack comm showed me help with simple scenario's. Please put your idea's you have or used in your projects.</p>
  
  <p>Thanks a lot. </p>