We have new versions of .net applications deployed every week for testing given in form of new build files. Can any one suggest how I can maintain many versions of the builds without having to keep many copies of builds and databases?
Here's what I have in mind :
- For each build maintain a new folder in inetpub > wwwroot
- Have one database
- Keep SQL Server stored procedures in same one database in different^schemas(*) or keep it in local folder drives (*not sure how to do this)
web.configfile point to same database for each of the builds, but somehow be able to suggest which build version of stored procedures to use for each build from the
web.config(again not sure how to do this)
Is this possible and how? A way of version control and deploy and maintain builds on a single db Or can anyone recommend other better methods for maintaining multiple build versions, any links or thoughts will be helpful