Schema Tools
Four tabs: Schema Compare, DDL Export, Data Import/Export and Version History.
#23.1Schema Compare
- Choose a Source Schema and a Target Schema (the target list excludes the source).
- Compare Schemas.
Results are summarised in three chips and listed one row per difference:
| Difference type | Meaning |
|---|---|
| Modified (amber) | The object exists in both schemas but its definition differs. |
| Missing in Target (red) | The object exists in the source only. |
| Missing in Source (blue) | The object exists in the target only. |
Every difference starts selected. Click a row to include or exclude it — deselected rows dim.
Generate Sync Script produces the DDL that would bring the target in line with the source for the selected differences only. The script is shown in a scrollable block with a Download button.
The sync script is not executed. Review it, and run it in the SQL editor when you are satisfied. Treat DROP statements in the script with particular care.
#23.2DDL Export
Choose a Schema, then toggle which Object Types to include — TABLE, VIEW, PROCEDURE, FUNCTION, PACKAGE, TRIGGER, SEQUENCE (all on by default; click a badge to toggle). Export Selected DDL downloads <SCHEMA>_DDL_Export.sql.
#23.3Data Import / Export
Two side-by-side panels.
Export Data — pick a Schema, a Table, and a Format:
| Format | Output |
|---|---|
| CSV Format | Comma-separated values. |
| JSON Format | An array of row objects. |
| INSERT Statements | Ready-to-run INSERT statements. |
Import Data — pick a Target Schema and Target Table, choose a file (.csv, .xlsx, .xls, .json), and press Import. The format is detected from the file extension. Column headers must match the target table’s column names.
#23.4Version History tab
Hosts the object version history module — see chapter 24.