Menu

DONE: Ability to generate a configuration backup with obfuscated data.

+1 vote

The purpose would be to migrate a safe copy of the configuration and data to a test, dev or training environment.

This data could be used for training purposes or to test/debug difficult-to-replicate production issues.

This would be especially useful when exporting config/data for dbFront support.

The obfuscated data should have the same characteristics as the source data but it should be impossible to extract any meaningful personal information.

in Features (Done) by (4.6k points)
recategorized by

1 Answer

0 votes

dbFront 1.1.2.273 now allows you to optionally obfuscate one or more tables during the export process.

All fields in the selected tables are obfuscated except key fields (Primary & Foreign Keys, and Unique Indexes).

The obfuscation process:

  • Overwrites all alphanumeric characters with a random character of the matching type. Uppercase, Lowercase and Digits are handled separately,
  • Replaces vowels with consonants to avoid creating real words,
  • Overwrites all numeric digits,
  • Shifts dates randomly +/- 90 days,
  • Randomizes boolean values,
  • Discards all BLOB values.

The intention is to create "valid" data that retains the original structure and characteristics but in which all identifiable information has been overwritten. The original length of all values is intentionally retained.

The objective is to create Test / Demo / Sample data that you can safely give to 3rd parties.

For more details see: Export / Import

by (52.4k points)
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...