Tools

The Tools menu (in the toolbar) gathers database-wide utilities.

Data Transfer

Copy tables — schema and rows — from one database to another, even across connections and engines (ElyraSQL ↔ SQLite).

1. Tools → Data transfer…
2. Pick a Source (connection + database) and a Target (connection + database). The target connects automatically if needed.
3. Choose All tables or Selected (tick the tables you want).
4. Options:
   • Create tables if missing — builds each target table from the source's columns and primary key.
   • Empty target tables first — clears existing rows before copying.
5. Transfer — a per-table report shows rows copied (and any errors).

Structure Synchronization

Compare two databases' schema and generate the statements that make the target match the source — new tables and missing/changed columns.

1. Tools → Structure synchronization…
2. Pick a Source and Target (connection + database).
3. Compare — the generated script is shown (executable lines plus -- comments for anything that only differs in the target).
4. Apply to target runs the executable statements.

Data Synchronization

Make a target table's rows match a source table's, keyed by the primary key.

1. Tools → Data synchronization…
2. Pick a Source (connection + database + table) and a Target (connection + database).
3. Optionally tick Delete target rows missing from source.
4. Compare — see counts (inserts / updates / deletes) and the generated statements. Apply to target runs them in one transaction.

Extract a slice

Reproducing a problem usually needs the rows involved — one customer, their orders, the products on those orders — not the whole database. Copying them by hand breaks on the first foreign key. A slice follows the keys for you.

1. Tools → Extract a slice…, or right-click a table → Extract a slice…
2. Pick the table to start from, and a Where condition — id = 4711, created_at >= '2024-01-01'. Empty takes the first rows.
3. Choose whether to include the rows that reference the starting rows.
4. Choose the output and Extract.

What goes in. Every row that anything in the slice points at, always — and their parents in turn — so the slice loads without a broken key. With the option ticked, also the rows that point at the starting rows, and the rows that point at those: a customer's orders and the orders' lines. Children are followed only downwards from where you started, never back out through a shared parent — the products on Ada's orders come along, but not every other order line that mentions those products.

What comes out, in your Downloads folder:

• SQLite file — tables, primary keys, foreign keys and rows, ready to open. Open as connection… adds it to the sidebar.
• SQL INSERTs — parents before children, for loading into a database that already has the schema (a dev database with your migrations applied).

The source is only ever read. Nothing is written to any server.

Data Generation

Fill a table with plausible test data.

1. Tools → Data generation…
2. Pick the connection, database and table, and a row count.
3. Generate.

A generator is inferred per column from its type and name — names, emails, country codes, dates, booleans, numbers — and a single integer primary key gets sequential values continuing after the current maximum. If you generate into the table you're browsing, the grid refreshes automatically.

Other tools