Let's say I have two Linux servers. One containing a desktop app database (running on a local network) and a webserver.
I want to automatically transfer each hour a database file (with a size of a few MB) from the local server to the web server to make updates.
The information needs to be encrypted and the server has to be authenticated in order to make the transaction.
I was thinking on SSH File Transfer protocol. My questions are:
Is it the best option?
What other options do I have?
What existent library / script can I use to make the task automated? (in both servers)