Redgate Test Data Manager

Sometimes, tables have a need for unique data across all of their rows. This is supported when masking via the use of the constraints section for each table in a masking file.

Example to set a column to be masked with uniqueness Toggle source code

{
  "tables": [
    {
      "schema": "Person",
      "name": "Person",
      ...
      "constraints": [
        {
          "type": "unique",
          "columns": [
            "Name"
          ]
        }
      ]
    }
  ]
}

Columns defined in a unique constraint will generate unique values when being masked.

Multiple columns can be included in a unique constraint. When this is the case, the combination of values across the columns will be unique when being masked.

Example to set multiple columns to be masked with uniqueness Toggle source code

{
  "tables": [
    {
      "schema": "Person",
      "name": "Person",
      ...
      "constraints": [
        {
          "type": "unique",
          "columns": [
             "FirstName",
             "LastName",
           ]
        }
      ]
    }
  ]
}

Redgate Test Data Manager

Masking with uniqueness

Cookies on red-gate.com