如何在SQL Azure中加密数据? [英] How to encrypt data in SQL Azure?

问题描述

我的研究确实表明我不能在SQL Azure中使用透明数据加密(TDE).

My research does show me that we cannot use Transparent Data Encryption (TDE) in SQL Azure.

在这方面，它们是否是在SQL Azure中加密数据的任何选项.

In this regard, are they any options for encrypting data in SQL Azure.

我不想在应用程序级别执行此加密/解密操作.

I do not want to have this Encrypt/Decrypt operations at application level.

谢谢

推荐答案

有关TechNet上SQL Azure支持和不支持哪种加密的深入说明:

There is an in depth explanation about which kinds of encryption are and are not supported by SQL Azure on TechNet:

http://technet.microsoft.com/en-us/magazine/hh351833.aspx

SQL Azure当前不支持标准数据加密SQL Server支持的机制.这些包括透明数据加密，非对称密钥，对称密钥和Transact-SQL诸如ENCRYPTBYPASSPHRASE和DECRYPTBYPASSPHRASE之类的功能，创建/更改/删除数据库密钥或创建/更改/删除主文件密钥

SQL Azure does not currently support the standard data-encryption mechanisms that SQL Server supports. These include transparent data encryption, asymmetric keys, symmetric keys, and Transact-SQL functions such as ENCRYPTBYPASSPHRASE and DECRYPTBYPASSPHRASE, CREATE/ALTER/DROP DATABASE ENCRYPTION KEY or CREATE/ALTER/DROP MASTER KEY

TL; DR:应用程序级别可能是您当前唯一的选择

TL;DR: Application level is probably your only choice right now

这篇关于如何在SQL Azure中加密数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！