Delete Old Data
After you encrypt your table, a new row of encrypted data is added, but the original data still exists in plaintext. Likewise, after decrypting your data, the ciphertext remains in the table. We strongly recommend you to remove this data.
To delete old data:
Log on to the CipherTrust Manager GUI.
Click Database Protection to open the application. The Databases screen displays the list of existing database connections, if any.
Click the desired database connection.
Click the Tables link.
On the Authorize Database screen, enter the Database Password to access the tables.
Under the Tables with Encrypted Columns section, click the table for which you want delete old data.
From the Table Actions drop-down list, select Delete Old Data. On the Delete Old Data for table for < table name > wizard:
a. On the Configuration screen, enter the Batch Size in which you want to delete the data.
b. Click Next.
c. Preview the SQL code to be executed. This code can’t be edited.
d. If you want to modify the Batch Size, click Edit, update the field, and click Next.
e. Click Next.
f. The Perform Operation screen shows the progress of the operation. A message Successfully deleted the old data is displayed on the screen.
g. Click Close to exit the wizard.