What is the best solution to transfer a database backup from a sql server to a buildserver( that its used for jenkins) automated

Question

My solution was to use

• sqlcmd to backup the database
• ftps to transfer the database
• sqlcmd to restore the backup on the building server.
• all of that will be executed by the jenkins, which is on the build server.

My question is that I can't find a secure ftp server-client that support command line. I tried with filezilla but it doesn't support cmd line.

• Do you know a good ftps server and client that support cmd line?
• Or do you have an other solution for my problem?

Why I am asking for help: - because i am stuck in the ftps transfer, using CLI.

Answer 1

FileZilla does support CLI. You can find more on that here.

You can also try SSLFTP.