CODEWITHSUNDEEP
sqlsql-serversql-server-2016always-encrypted
Tom
Tom

Reputation: 1373

SQL Server Always Encrypted

I'm using SQL Server "Always Encrypted" to encrypt data in one table for a few columns.

I need to know is that possible to add "Always Encrypted" to my whole database at once?

Any idea?

Upvotes: 1

Views: 268

Answers (2)

abdurrahimefe
abdurrahimefe

Reputation: 123

Right Click Database-->Tasks-->Encrypt Columns. All table columns can be encrypted at once

Upvotes: 0

Omar Jaber
Omar Jaber

Reputation: 11

Always Encrypted operates at the column level not database or table. Yes, you can encrypt all the columns in al the tables for a entire database. However, there are restriction on types, and limited operation support o encrypted types. My advice is to use AE on very sensitive columns and otherwise use TDE, which is at Rest encryption.

Upvotes: 1

Related Questions