Redgate Test Data Manager

Anonymization known limitations

Uniqueness and determinism

  • Columns cannot be masked both deterministically and uniquely.
  • A pattern based dataset cannot be used to mask a column uniquely.
  • The same value may be masked differently across columns if the columns have different lengths, even if the same dataset is used and both columns are masked deterministically.

PostgreSQL

  • Inherited tables are not supported.

Other

  • Masking may fail on columns that have a check constraint on them.
  • Masking can only be done on string, date and exact numeric data types.
  • Masking cannot be done within XML or JSON.
  • Datasets involving dates cannot be customised.
  • If masking fails while partially complete, any changes made to the database cannot be undone. The database should be considered unusable and masking should not be repeated on it.

Didn't find what you were looking for?