Redgate Test Data Manager

Individual overrides

Where to add an override

If you want to correct a column or table individually, then you can include configuration in the "tables"  section of the options file.

The schema name, table name, and column name properties need to match the casing of the corresponding items in the database being masked.

Add or override a column classification

To add or override a column classification, add the column to your options file, including a "type" on the column.

Example to override a default column classification Toggle source code

  1. {
  2. "tables": [
  3. {
  4. "schema": "Person",
  5. "name": "Person",
  6. "columns": [
  7. {
  8. "name": "Name",
  9. "type": "GivenNames"
  10. }
  11. ]
  12. }
  13. ]
  14. }

Exclude a table or column

To exclude a table or column from being processed, add "exclude": true  to the corresponding JSON node. Make sure to use true  without quotes, as it'sBoolean value.

NB The table or column will still be present in the classification file, but if that file is used in Anonymize Map, then it will be set to be ignored by Anonymize Mask.

Example to exclude an entire table Toggle source code

  1. {
  2. "tables": [
  3. {
  4. "schema": "Person",
  5. "name": "PersonPhone",
  6. "exclude": true
  7. }
  8. ]
  9. }

Example to exclude a single column Toggle source code

  1. {
  2. "tables": [
  3. {
  4. "schema": "Person",
  5. "name": "PersonPhone",
  6. "columns": [
  7. {
  8. "name": "PhoneNumber",
  9. "exclude": true
  10. }
  11. ]
  12. }
  13. ]
  14. }

Didn't find what you were looking for?