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