Best Practice to migrate data via SFTP

Hi, NullPointah

If SFTP is the only allowed route, keep it simple but reliable. Capture only changed rows using CDC or a modified-date column, then export daily deltas with SQL Server Agent or a PowerShell job. Add checksums and versioned filenames, and push files over SFTP during low-traffic hours. On the other side, drop them in a landing folder, verify hashes, and load into staging before merging into production tables.

If maintaining scripts sounds like too much overhead, you could use a managed data-transfer service that supports both SFTP and SQL Server. I’ve had good results with Skyvia - it handles scheduling, schema changes, and monitoring without much manual setup.