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).
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).
Currently I taking these packages to the remote servers and deploying them using MSBUILD.
Now I need
One click deployment approach for this architecture. (an idea)
MSBUILD commands that I could use (if possible point me to the complete list)
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)
Mostly I think BuildProcesstemplate.xaml has to be edited. Guide in this approach as well.
Things i referred (not helpful in my case)
- PDC 09 talk by Vishal R. Joshi
- Continuous deployment with TFS 2010 Build Agent (Hakan Forss blog)
- Web Deployment Made Awesome: If You're Using XCopy, You're Doing It Wrong (Scott Hanselman).
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.
Thanks a lot.