c# - Automated deployment using CI tool -

i working on automated deployment of web applications using jenkins. planning provide end user user interface allows choose svn tag , enters userid , password initiate deployment. know, if there standards follow job.

1. does automated job should include building solution before deploying application (or) ok if developer stores result of msbuild i.e., required binaries , sql in svn tag start xcopy task.

2. if build preferred first, how deploying sql scripts svn since might vary build build. , think might bad idea allow user choose sql script deployment. if mistake, chooses intial setup script, might problem. so, how deal sql deployment in scenario able integrate deployment process.

it better build once, store binary somewhere (e.g. nuget) , use deployments. see

http://www.informit.com/articles/article.aspx?p=1621865&seqnum=3

for sql scripts use db migration tool such dbdeploy. following article colleague describes whole process our cd tool called go use information there jenkins.

http://lyricsoft.blogspot.in/2012/08/we-are-often-asked-about-using.html