I work as a freelance web dev, and up until now have been ftping my scripts / databases / static files to my web server manually, but I m finding that is too error prone. So I m looking for an app to automate uploading new and updated scripts / files / databases / etc. I know a lot of independent devs use WinSCP or Unison, but I don t think those apps can synch databases.
Does anyone have any other suggestions? It doesn t need to be anything overly feature rich as I m not working within a team or across multiple operating systems or anything like that. I can purchase any reasonably priced license if necesary. My work is primarily for PHP / MySQL / Apache on a Windows system, and then uploaded to a Linux / Apache server.
thanks for your time!