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:

How It Works

  1. Rows are extracted from the source in batches to avoid memory issues
  2. Each batch is inserted into the corresponding table on the target
  3. Progress is displayed in real time (e.g. "500/2000 rows")

Row Limit

You can set a maximum number of rows per table:

LimitBehavior
None (default)All rows are cloned
1,000Only the first 1,000 rows of each table are copied
10,000Only 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