>Hi Experts,
>
>I have setup a Linux (Ubuntu 14.04) Server machine with the OpenSSH, LAMP features installed.
>
>Obviously, we are using MySQL for our database, and was thinking of using SFTP because of OpenSSH, which is supposed to more secure (right?) for app updating purposes, instead of regular FTP or FTPS.
>
>I have come across Craig Boyd's cool stuff - VFPCONNECT.FLL - but it's for FTP and FTPS - not SFTP.
>
>I have also come across Carlos Alloatti's libcurl class which seems to handle FTP and FTPS as well.
>
>Any other stuff you guys can point me to?
>
>Thanks in advance.
>
>Dennis

Both SFTP and FTPS are secure and communicate via an encrypted channel, not much difference there. The main difference I think you will find is that SFTP will communicate over a single port whereas FTPS will require the additional port 990 to be open as well as additional passive listening posts. That might have firewall setup implications for you.

Look at Chilkat FTP controls - the entire Chilkat suite is excellent. Also look at IPWorks - also very highly recommended.

http://www.chilkatsoft.com/ftp-activex.asp

http://www.nsoftware.com/ipworks/

Disclaimer: Just a non-expert opinion.

.