dbFront 126.96.36.1993 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