Tools
The Tools menu (in the toolbar) gathers database-wide utilities.
Data Transfer
Requires Premium
Copy tables — schema and rows — from one database to another, even across connections and engines (ElyraSQL ↔ SQLite).
- Tools → Data transfer…
- Pick a Source (connection + database) and a Target (connection + database). The target connects automatically if needed.
- Choose All tables or Selected (tick the tables you want).
- 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.
- Transfer — a per-table report shows rows copied (and any errors).
Note
Secondary indexes and foreign keys are not reproduced (columns + primary key only). Rows are streamed in batches.
Structure Synchronization
Requires Premium
Compare two databases' schema and generate the statements that make the target match the source — new tables and missing/changed columns.
- Tools → Structure synchronization…
- Pick a Source and Target (connection + database).
- Compare — the generated script is shown (executable lines plus
--comments for anything that only differs in the target). - Apply to target runs the executable statements.
Non-destructive
Nothing is ever dropped — target-only tables/columns are reported as
comments. Added columns are nullable so applying to a populated table can't
fail. MODIFY COLUMN is emitted for ElyraSQL targets only (SQLite can't
alter column types).
Data Synchronization
Requires Premium
Make a target table's rows match a source table's, keyed by the primary key.
- Tools → Data synchronization…
- Pick a Source (connection + database + table) and a Target (connection + database).
- Optionally tick Delete target rows missing from source.
- Compare — see counts (inserts / updates / deletes) and the generated statements. Apply to target runs them in one transaction.
Note
Requires a single-column primary key. Both sides are diffed in memory, so very large tables (>100k rows) are declined.
Data Generation
Requires Pro
Fill a table with plausible test data.
- Tools → Data generation…
- Pick the connection, database and table, and a row count.
- 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
| Tool | What it does |
|---|---|
| Data dictionary… | Dumps every object's CREATE statement into a new query tab (Pro) |
| Console | Opens a new query tab |
| Find in database… | Opens the command palette to jump to any table |
| Server monitor… | The live process list (Premium, ElyraSQL only) |
| History log | Your query history |