The database update procedure requires the MS SQL Server tool bcp.exe. Make sure bcp.exe is somewhere in your PATH. The tool will first read and encrypt all the column data, then use bcp.exe to upload it to the database.
The process can be rolled back at any time by closing the application or clicking 'Connect/Disconnect' on the Options tab.
The following steps describe how to perform column encryption:
- Once you have connected to your database (as outlined in Key Ring Tab), stop IIS.
- Select the Key Ring tab.
- Click 'Column Keys: Blank'.
A pop-up window will display:
- Enter and verify 'Column Key 1' fields.
If encryption is currently not used, leave this area blank.
- Click 'OK'.
A second pop-up window will display
- Enter and verify the 'Column Key 2' fields.
- Click 'OK'.
- Select the column to encrypt from the 'Column Name' dropdown list.
- Click 'Add Key'.
- Repeat Steps 8 and 9 for all of the columns listed on the Encrypted Columns page.
- Start IIS.