开发者

sql server encrypted column to be decrypted on another server

开发者 https://www.devze.com 2023-04-09 03:38 出处:网络
How to: Encrypt a Column of Data shows how to encrypt a column of data in sql server and decrypt it in the same database instance the encryption p开发者_如何学编程art is exactly what I want however th

How to: Encrypt a Column of Data shows how to encrypt a column of data in sql server and decrypt it in the same database instance the encryption p开发者_如何学编程art is exactly what I want however the decryption process would be different for me :

I will create csv files from the tables with encrypted column and will import these files into another instance of sql server where the other server should be able to decrypt .

A. how can I do the encryption on server A and do the decryption on server B ? (is it possible to send the other server the certificate file ?)

B.the encryptor server is sql server 2008 can we do the decryption on sql server 2005 or develop .net module for doing the decryption ?


OK I found the answer here for part A .

and for part B the answer is yes the decryption can be done in sql 2005 and I just did it .

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号