APPX Data File Encryption

Choose a chapter or open a topic below.

1. Chapter 1Before starting

   Understand the scope and protect the keys before making a change.

   • 0What this manual covers
   • 0What can be encrypted
   • 0Encryption technology
   • 0Passphrase, encryption keys, and index files
   • 0Keep the keys safe

2. Chapter 2Prepare the test system

   Back up the test system, set the passphrase, and open DMO file management.

   • 0Back up and record the starting state
   • 0Set the system passphrase
   • 0Open DMO Data File Management

3. Chapter 3Encrypt PROSPECT

   Encrypt one file and export it while it remains encrypted.

   • 0Select and export only PROSPECT
   • 0Set the file key and replace the file
   • 0Export the encrypted file to CSV

4. Chapter 4Decrypt PROSPECT

   Recreate PROSPECT without encryption and check its records.

   • 0Export before clearing the file key
   • 0Replace and verify the decrypted file

5. Chapter 5Encrypt the DMO database

   Use a dedicated group to encrypt every eligible DMO datafile.

   • 0Inventory and export the eligible files
   • 0Create and assign a dedicated encryption group
   • 0Replace and check every converted file

6. Chapter 6Decrypt the DMO database

   Export all affected files and recreate them without encryption.

   • 0Export every affected file first
   • 0Clear the encryption settings and replace
   • 0Verify the decrypted database

7. Chapter 7Analysis and recovery

   Verify encrypted files and check a recovered working copy.

   • 0Check an encrypted file through APPX
   • 0Analyze a working copy
   • 0Decide whether to rebuild a missing or damaged index
   • 0Physical recovery
   • 0Extract records flagged as deleted
   • 0Test recovery on a disposable copy

8. Chapter 8Routine operation and compatibility

   Manage restoration, key changes, APPX ODBC, and Unicode.

   • 0Backups, restoration, and another server
   • 0Share encrypted files across servers
   • 0Change a key or the system passphrase
   • 0APPX ODBC and external database interfaces
   • 0Check ODBC access before converting a file
   • 0ODBC access in the 6.2.1 test
   • 0Unicode in APPX 6.2.1
   • 0When a check fails

9. Appendix AReference and completion checks

   Keep a completion record and find the supporting references.

   • 0Desktop Client keys
   • 0Conversion completion record
   • 0Further reading