Best Practice to migrate data via SFTP

Hi olafhelper - I meant to say that when the project solution was designed, they only approved SFTP as the only integration pattern for transfering data back and forth between on-premise and cloud (this is not directly related to DB connections, but in general).

There won't be a VPN, direct-link, etc. Only the SFTP pattern is available, hence this question is about navigating through these technical limitations and constrains if that makes sense.

In other words, if you were constrained by only having an SFTP channel, what would be your best proposal for extracting the incremental data of the cloud microsoft sql server so it can be brought into on-premises at an acceptable rate, latency, etc.