USE AdventureWorks2016
-- Create Certificates named "TESTINGC02"
-- which is protected by DMK,
-- start at 19Feb2019 12:00:00, end at 31Jan2020 13:00:00
CREATE CERTIFICATE TESTINGC02
WITH SUBJECT = 'subject name of the certification',
START_DATE = '20190219 12:00:00',
EXPIRY_DATE = '20201031 13:00:00'

USE AdventureWorks2016
-- Create Certificates named "TESTINGC03"
-- which is protected by Password
-- start at 19Feb2019 12:00:00, end at 31Jan2020 13:00:00
CREATE CERTIFICATE TESTINGC03
ENCRYPTION BY PASSWORD = 'P@ssw0rd'
WITH SUBJECT = 'subject name of the certification',
START_DATE = '20190219 12:00:00',
EXPIRY_DATE = '20201031 13:00:00'

USE AdventureWorks2016
BACKUP CERTIFICATE TESTINGC03 TO FILE = 'C:\Sources\CERTIFICATE_BK.cer'
WITH PRIVATE KEY(
FILE = 'C:\Sources\PRIVATE.pvk',
ENCRYPTION BY PASSWORD = 'P@ssw0rd',
DECRYPTION BY PASSWORD = 'P@ssw0rd'
);

USE AdventureWorks2016
CREATE CERTIFICATE TESTING03
ENCRYPTION BY PASSWORD = 'P@ssw0rd'
FROM FILE = 'C:\Sources\CERTIFICATE_BK.cer'
WITH PRIVATE KEY (
File = 'C:\Sources\PRIVATE.pvk',
DECRYPTION BY PASSWORD = 'P@ssw0rd'
);

USE AdventureWorks2016
DROP CERTIFICATE TESTING03

USE AdventureWorks2016
ALTER CERTIFICATE TESTINGC03
WITH PRIVATE KEY(
DECRYPTION BY PASSWORD = 'P@ssw0rd'
);

USE AdventureWorks2016
ALTER CERTIFICATE TESTINGC03
WITH PRIVATE KEY(
ENCRYPTION BY PASSWORD = 'P@ssw0rd'
);

USE AdventureWorks2016
ALTER CERTIFICATE TESTINGC02
WITH PRIVATE KEY(
DECRYPTION BY PASSWORD = 'P@ssw0rd',
ENCRYPTION BY PASSWORD = 'NewP@ssw0rd'
);