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: 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?