Redgate Test Data Manager

Creating an anonymization treatment

Step 1: Navigate to Your Database Model

  1. Go to Database models in the left sidebar
  2. Click on the database model you want to create a treatment for
  3. Click + Create treatment

Step 2: Configure the Treatment

  1. Treatment name: Enter a descriptive name (e.g., "Customer_Data_Anonymization")
  2. Treatment type: Select Replace sensitive data
    • Replace sensitive data: Anonymizes PII by replacing it with generated data
    • Subset data: Reduces database size (see Subsetting treatments)
  3. Click Create treatment

Step 3: Wait for Initialization

After creating the treatment, Test Data Manager automatically:

  • Scans your database structure
  • Identifies columns containing sensitive data
  • Assigns appropriate masking datasets based on column names and data types

This process usually takes a few seconds but may take longer for large or complex databases. 

What's being detected? Test Data Manager uses built-in classification rules to identify common PII types like names, addresses, email addresses, phone numbers, and dates of birth. See Default classifications and datasets for the full list. 

What Happens Next 

Treatment shows Summary and Anonymization tabs
Next step: Review the detected columns
→ Reviewing and Editing Masking Rules

Related Pages

← Back to Anonymization Treatments Overview
→ Reviewing and Editing Masking Rules
→ Default classifications and datasets


Didn't find what you were looking for?