Forum Discussion
Best Practice to migrate data via SFTP
Hi, I am currently working on a project that will be migrating part of an on-premise solution to the cloud (AWS). As a result, we are breaking the link of our reporting tool that feeds directly ...
The only approved integration pattern for data transfer between on-premise and cloud is via SFTP.
NullPointah , why do you think so? Of course you can access server running in the cloud over internet, equal to an on-premise server.
And no, SFTP is no standard way (even because by default there isn't on on the target server in the cloud).
Take some time to read articles about colud/SQL Azure etc.
- 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.they only approved SFTP as the only integration pattern for transfering data back and forth between on-premise and cloud
That's nonsense and nosense is always difficult to implement.
