Source and target schemas do not match
Published 06 March 2025
The database schema of the source and target databases do not match. For subsetting to work correctly, the source and target databases must have the same schema.
How to fix
Ensure schema alignment between your source and target databases before running the subsetter.
Steps
- Compare database schemas - check table structures, column names, and data types
- Update target database to match the source schema
- Deploy schema changes using your preferred database deployment tool
- Verify alignment before re-running the subsetter
Common mismatches
Missing tables: Target database lacks tables present in source
Column differences: Different column names, data types, or constraints
Schema versions: Source database updated but target still on older version
Index variations: Different indexes between databases (may cause warnings)
Bypassing this check
If you're confident the schemas are compatible despite differences, use:
rgsubset run --force
Warning: Using --force
may cause subsetting to fail if schemas are truly incompatible.