Version Diff¶

Compare two snapshots of a diagram to visually review changes and auto-generate Alter Scripts for database migration.

Version History¶

Every time a diagram is saved, a version history entry is automatically recorded.

• View previous versions in the Version History tab in the right panel
• Each version shows the save timestamp and author information
• Select any two versions to start the comparison

Visual Diff¶

When two versions are selected, changes are visualized directly on the canvas. Different visual effects are applied based on the type of change.

Change Indicators¶

Change List Panel¶

A Change List Panel is displayed next to the canvas:

• Changes categorized by type (Added/Modified/Deleted)
• Click each item to auto-navigate to its position on the canvas
• View detailed change content (previous value → new value)

Practical Workflow: Schema Change Management¶

A step-by-step guide to using the version diff feature in practice.

Scenario: Adding a Column to the Customer Table¶

1. Make the change: Add a Last Login Datetime column to the Customer entity
2. Save: A new version is automatically created when changes are saved
3. Run comparison: Select the previous version and the current version in Version History
4. Review Visual Diff: The Customer entity is highlighted 🟡 yellow on the canvas, and the Last Login Datetime column appears 🟢 green
5. Generate Alter Script: Click the Generate Alter Script button from the diff results
6. Review and apply the script:

   -- Alter Script (auto-generated)
   ALTER TABLE CUSTOMER
     ADD COLUMN LAST_LOGIN_DTIM TIMESTAMP;
   

7. Apply the generated script to the development DB

Diff Engine¶

The Diff Engine structurally compares two snapshots to analyze changes:

Alter Script Integration¶

Based on the diff results, an Alter Script is auto-generated via SQL Export. This produces a migration script to convert the current schema to the target schema.

Supported ALTER Statements¶