I need to securely transfer data from a SQL Server in Microsoft Azure to a SQL Server on-premises. I have been researching different methods but I have not found the right way.
Following is the list of what I have considered.
- Encrypted SQL Server connection. How can I selectively enforce encryption on particular IP addresses? The source SQL Server services other clients that are not ready for enforced encryption.
- Azure Data Factory Integration Runtime. It looks like it is in alpha version and designed for full integration and not file sharing between independent parties.
- SSH Tunnel. What is the best way to setup SSH server and client on Windows?
- File transfer using SFTP. This method is inefficient and does not allow for real time access.
- Other method that you suggest?
No comments:
Post a Comment