User Profile
NullPointah
Copper Contributor
Joined Mar 15, 2023
User Widgets
Recent Discussions
Re: 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.2.7KViews0likes1CommentBest 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 to the on-premise database (soon to be cloud based database). The database is a microsoft sql server and let's assume it is on a supported version (currently waiting for exact version). For this project, the only approved integration pattern for data transfer between on-premise and cloud is via SFTP. This is the integration pattern approved by architecture governance. We won't be able to connect our reporting tool to the now cloud to be DB (no direct-link, no vpn, etc). Understanding that SFTP may not be the most elegant solution, what would be the best way using Microsoft SQL Server features to produce file(s) that can be sent on-premise via sftp and use these to: 1.- Load directly to the reporting tool. or 2.- Use to populate a replica of the cloud DB on-premise. We would be interested in changes only (not dumping the entire DB every time). Given my limited knowledge on the technology, I can think of a differential backup, send it via sftp, restore on-premise. Have the backup scheduled for every x min? The deltas won't be gigabytes and they will actually be small (at least that is the expectation). Thanks3.2KViews0likes5Comments
Recent Blog Articles
No content to show