How do you handle a situation where there are no seperate development and integration environments? Like we have a development web server and database server. Each developer using TFS gets code into their local machine, checks out-makes changes-checks in. While doing this they are changing the development database using stored procedures etc. Sometimes this is breaking build. when this happens some developers are stuck until others are done fixing it. I am not sure if they will add another integration environment. In my previous projects we had a build engineer to do the automation builds.
How do i add automation to build in this current environment? we work with visual studio 2013 for asp.net, TFS and sql server 2012. I haven't worked with tfs earlier(i mean using API for automating builds etc) .
Should we have another copy of sql server development database?
Thanks for your time.