Automating Releases with SFTP

I’m trying to automate the deployment process for a website. I’m using Psake for the build process and Migrator.Net for the db migrations. Which left the problem of getting the code to the server. I’ve taken a stab that this using this guide to setup SFTP with a restricted user with just SFTP access using public/private keys.

Next was to automate the file upload, first I just used at batch file and psftp.exe, this worked except it re-uploads everything, much of which didn’t change. So, next was FileZilla, no luck there. Finally, WinSCP which works ok, but it doesn’t seem to allow a fully automated sync of files, but it does get close.