Redgate Test Data Manager

Running a subsetting treatment

Prerequisites

  • You've created and configured your treatment
  • Chosen desired size OR starting tables approach
  • Creating a subsetting treatment

Running a Subsetting Treatment

Step 1: Start the Treatment

  1. Click Run Subset in the top-right corner
  2. The "Run treatment" panel appears

Step 2: Configure Source and Target Databases

Source database: The database to extract data from

  • Select an existing connection from the dropdown, OR
  • Click + Add connection to create a new one

Target database: The database to copy the subset to

  • Select an existing connection from the dropdown, OR
  • Click + Add connection to create a new one


Target database requirements:

  • Must have the same schema as the source database
  • Will be cleared before subsetting (existing data is removed)
  • Must be a non-production database 
Subsetting modifies the source and target database: The treatment will clear existing data and copy the subset to the target. Make sure you're connecting to a non-production database you're prepared to overwrite.

Step 3: Configure Options

  • Ignore additional objects in target database: Check this option if your target database contains objects that are not present in the source database (for example, Oracle public synonyms or tables from other schemas). When enabled, subsetting will proceed and only operate on the matching objects, rather than failing due to the mismatch.

Step 4: Run the Treatment

  1. Review the source and target connection details
  2. Click Run
  3. Monitor progress

What happens during execution

- TDM extracts data from source
- Clears target database
- Copies subset to target
- Maintains referential integrity

Related pages

← Back to Configuring desired size / starting tables
→ Download treatment for CLI use
→ Subsetting troubleshooting


Didn't find what you were looking for?