问题描述
当前，我们有一个使用SSIS将数据从内存中服务器(有限的表集)传输到SQL Azure的过程.我只是想知道SSIS中是否有任何规定可以在将数据从一个数据库复制到另一个数据库时在线加密数据.
Currently we have a process of transferring data from on-perm server (limited set of table) to SQL Azure using SSIS. I was just wondering is there any provision in SSIS where we can encrypt the data on wire as its gets copied from one database to the other.
推荐答案
默认情况下，与Azure SQL数据库的所有连接都是加密的，未加密的连接将被拒绝.
All connections to Azure SQL Database are encrypted by default and unencrypted connections are rejected.
当SSIS连接到Azure SQL数据库时，目标数据库将在登录过程之前协商SSL，并且所有后续交互都将被加密.
When SSIS connects to Azure SQL Database, the destination database will negotiate SSL before the login process and all subsequent interactions will be encrypted.
这篇关于SSIS是否在网络上提供任何类型的加密?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！