Wiki source code of sql-tde

Version 3.1 by Rudi Marais on 2025/02/26 13:07
Show last authors
1 = Fancy =
2
3
4 sdfswedfsdf
5
6 {{mention reference="XWiki.nikhils" style="FULL_NAME" anchor="XWiki-nikhils-rfwngb"/}}
7
8
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}}