可用于加密SQL Server Express数据库的选项有哪些？ [英] What are the options available to encrypt a SQL Server Express database?

问题描述

我们有一个销售人员团队，他们经常携带装载有SQL Server Express数据库中的销售数据的笔记本电脑。可用于加密SQL Server Express数据库的选项有哪些？

We have a team of sales persons who travel often carrying a laptop loaded with Sales data in a SQL Server Express database. What are the options available to encrypt a SQL Server Express database?

推荐答案

您的威胁模式是什么？你想阻止一个偷窃笔记本电脑或一个坚定的黑客的休闲小偷？您是否正在保护数据或模式？

What's your threat model? Are you trying to stop a casual thief who's stolen a laptop, or a determined hacker? Are you trying to protect just the data, or also the schema?

如果您使用SQL Server Express 2005或更高版本，则它支持本机非对称加密 。但是，如果您要阻止一个确定的黑客，那么我认为最好的选择是使用 TrueCrypt 或Vista / Windows 7的 BitLocker 。

If you're using SQL Server Express 2005 or higher, then it supports native asymmetric encryption. But if you're trying to stop a determined hacker, then I think the best option would be to encrypt the whole disk using something like TrueCrypt, or BitLocker for Vista/Windows7.

这篇关于可用于加密SQL Server Express数据库的选项有哪些？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！