We started using TFS2010 in the company I work for. We create web applications for e-commerce (trading platforms). I am creating a custom template for deploying web projects after assembly using an assembly template. I looked at the deployment tool on the Internet, but MSDN seems to indicate that it can only perform initial deployments, and I need to be able to incrementally deploy with the same script.
I am thinking of using the invokeActivity operation in the template to use powershell to complete the job, by specifying an FTP script that automatically copies the assembly output to the specified FTP site and then runs SQL (update) scripts, if necessary, using SSH or s powershell to delete the interactive session. (possibly specified in a separate SQL script)
There are some unknowns to me that I cannot understand due to the use of google:
When starting the build, can I let the user specify the script in the source control (for example $(source)\scripts\ftpscript.ps1) as the script to be used? Will powershell be able to access / use this file? or should I copy it to the assembly directory and indicate when I started it? (I don’t know how to configure the template to receive files from the source control, so a pointer to useful information on how to do this will be greatly appreciated)
If the previous one just doesn’t work at all, can I create the \ scripts \ folder in my project on the site, commit this to control the source code, and then use it BuildDetail.DropLocationRoot & "\scripts\"as the location for the script and make a copy from the script files by including the force copy option?