Data
The Data component copies the rows from your tables from the source project to the target project.
What Is Copied
All rows from all tables in the public schema (and other configured schemas), except:
- Tables excluded by ignore rules
- Tables beyond the row limit if configured
How It Works
- Rows are extracted from the source in batches to avoid memory issues
- Each batch is inserted into the corresponding table on the target
- Progress is displayed in real time (e.g. "500/2000 rows")
Row Limit
You can set a maximum number of rows per table:
| Limit | Behavior |
|---|---|
| None (default) | All rows are cloned |
| 1,000 | Only the first 1,000 rows of each table are copied |
| 10,000 | Only the first 10,000 rows of each table are copied |
This is useful for creating a staging environment with a reduced dataset.
Re-cloning Data
Warning: Data cloning inserts rows without checking for duplicates. If you run two data clones in a row, the rows will be duplicated.
To avoid this:
- Use Schema only mode for structure updates
- Clear the target tables before re-cloning data
- Or use scheduled clones which handle this case
Large Tables
Tables with more than 100,000 rows are flagged during the preview. They will take longer to clone but will work normally.
For very large tables (millions of rows), consider:
- Setting a row limit
- Excluding them via ignore rules
- Cloning schema only
Insertion Order
Data is inserted after the full schema has been created (tables, constraints, indexes). This ensures that:
- Foreign key constraints are respected
- Indexes are in place for performance
- Sequences are synchronized
Next Steps
- Tables and schema — The structure copied before the data
- Ignore rules — Exclude tables
- Clone options — Configure the row limit