Currently I'm tasked with doing the daily build. We have an ASP.NET 2005 website with a SQL Server 2005 backend. Our current source control is Visual Source Safe 2005.
At this point, I use the brute-force method of daily builds.
- Get Latest version of source code
- Get Latest version of Database release script
- Backup old website files to a directory
- Publish new code to my local machine
- Run on my server to keep the test/stage site working
- Push newly created files to the website
- Run SQL Script on test database (assuming updates, otherwise I don't bother)
- Test website on the Test Server.
Looking at the idea of automated builds intrigues me since it means that I do less each morning. How would you recommend I proceed? I want to have a fully fleshed out idea before I present it to my boss.