Windows CMD line 'sftp' authentication with a password

Question

I'm trying to automate file upload by creating .bat file which when run will upload files to SFTP server. I would like to automate this process, but sftp command line asks for password. Is there a way to enter the password in .bat file to automate it?

This is the code I'm using. It works, but user needs to enter the password. Is there a way to create batch file where password will be entered automatically?

sftp user@ip
password
put C:\Users\user\Desktop\folder\* /public_html/upload

Answer 1

I assume that you use (Win32-)OpenSSH sftp. It does not have any way to provide a password, on purpose.

• There are workarounds, covered for example in:
  How to run the sftp command with a password from Bash script?
  Though these use tools, which are not readily available on Windows.

• You should use a public key authentication instead.

• Or use another scriptable Windows SFTP client.
  See Secure FTP using Windows batch script.