I have a web application that is used by several different clients. At the moment the process of updating their end with any changes is like so:
- Publish/Compile App
- Put relevant files into a zip (not web.config as different db paths for each client and don't want to overwrite)
- Generate scripts on SQL Server for all Stored Procedures
- Add to zip
- Upload zip to Web
- WPF App I created that runs from client server downloads zip, extracts files to web app folder and executes scripts for sql server stored procedures