Wiki source code of sql-tde
Version 2.1 by Rudi Marais on 2023/01/25 12:52
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
2.1 | 1 | {{code language="sql"}} |
| 2 | USE master; | ||
| 3 | GO | ||
| 4 | CREATE MASTER KEY ENCRYPTION BY PASSWORD = '******'; | ||
| 5 | GO | ||
| 6 | |||
| 7 | CREATE CERTIFICATE EBSphere_TDE_SQL2019_Cert WITH SUBJECT = 'Database_Encryption'; | ||
| 8 | GO | ||
| 9 | |||
| 10 | BACKUP CERTIFICATE EBSphere_TDE_SQL2019_Cert TO FILE = 'D:\temp\EBSphere_TDE_SQL2019_Cert' | ||
| 11 | WITH PRIVATE KEY (file = 'D:\temp\EBSphere_TDE_SQL2019_Cert_Key.pvk', | ||
| 12 | ENCRYPTION BY PASSWORD='*****') | ||
| 13 | |||
| 14 | USE Everest_TDE_Master; | ||
| 15 | GO | ||
| 16 | CREATE DATABASE ENCRYPTION KEY | ||
| 17 | WITH ALGORITHM = AES_256 | ||
| 18 | ENCRYPTION BY SERVER CERTIFICATE EBSphere_TDE_SQL2019_Cert; | ||
| 19 | GO | ||
| 20 | ALTER DATABASE Everest_TDE_Master | ||
| 21 | SET ENCRYPTION ON; | ||
| 22 | GO | ||
| 23 | |||
| 24 | USE Everest_TDE_Master_Documents; | ||
| 25 | GO | ||
| 26 | CREATE DATABASE ENCRYPTION KEY | ||
| 27 | WITH ALGORITHM = AES_256 | ||
| 28 | ENCRYPTION BY SERVER CERTIFICATE EBSphere_TDE_SQL2019_Cert; | ||
| 29 | GO | ||
| 30 | ALTER DATABASE Everest_TDE_Master_Documents | ||
| 31 | SET ENCRYPTION ON; | ||
| 32 | GO | ||
| 33 | {{/code}} |