Hi,

I would like to encrypt an existing database.

Is this possible and what would be steps to accomplish that?

Regards

Mike,

Yes, it is possible but encryption is defined on a table basis, not for the whole database.
For each table you want to be encrypted on disk, just alter the table:ALTER TABLE <YourTable> ENCRYPTED
To decipher it back, ALTER TABLE <YourTable> UNENCRYPTED.
The encryption password is defined on the engine, all tables use the same password.
It's also possible to encrypt communications and the database catalog using the same password.

--
Fernando Dias
[Team Elevate]

Hi Fernando,

Thanks for the information. I will try this out.

Regards,

Mike

Any idea how to check if an table is encrypted?

Nevermind.

With HxD I could check the content.

<<Mike wrote:

Any idea how to check if an table is encrypted?
>>


Query the Tables - encrypted field

(e.g.  SELECT Name,Encrypted FROM Information.Tables)
Raul

Raul


Example

select Encypted from information.tables where name = 'Contacts'



Roy Lambert

Got it. Thank you all!