User-219423983 posted
Hi rabih matar,
rabih matar
How to use SqlBulkCopy to bulk insert into a table that has columns that are encrypted ( using sql server column level encryption)
As I searched, I think you’d better first have a look at below link to know how the Column Encryption works. For your need, you could change your mind by using
Table valued parameter to pass the values to sql server 2012, then use
EncryptByKey method to protect each record of the values.
https://www.mssqltips.com/sqlservertip/2431/sql-server-column-level-encryption-example-using-symmetric-keys/
Besides, there’s a new feature
“Always Encrypted” in SQL Server 2016 and you could have a look. This feature enhances ADO.NET client libraries and ciphertext to encrypt and decrypt data. Use Always Encrypted, the data is always encrypted, you can perform actions on the encrypted
data without first to decrypt them.
Best Regards,
Weibo Zhang
