| Schema comparison focus | PostgreSQL + MySQL; same engine | PostgreSQL databases or schemas; same major version | MySQL live databases, models and SQL scripts | Multi-engine; advanced capabilities vary by engine | Multi-engine; capabilities vary by database |
|---|
| Compare & generate SQL | Full or selected objects; review before apply | Object differences + selected synchronization SQL | Schema diff, synchronization + SQL generation | Schema comparison + generated migration scripts | Database diff + changelog-based changes |
|---|
| Environment promotion | Reviewed source → target sync; protection per connection | Run generated synchronization SQL | Synchronize chosen objects between sources | Versioned migrations + CI/CD workflows | Versioned changesets + automated deployment flows |
|---|
| History & recovery | Local run SQL, snapshots and reviewed rollback scripts | No migration ledger established here¹ | SQL history; no versioned release ledger established here¹ | Migration history, validation + undo migrations | Tracked changesets, history + rollback definitions |
|---|
| Drift & verification | Pre-apply schema check; recompare and inspect run results | Compare database/schema state on demand | Compare live database or model state | Drift and change reports | Drift inspection + deployment tracking |
|---|
| Lower-environment data | Filtered/selected rows, relations, row limits + fixed overrides | Not established in Schema Diff docs¹ | Data editing/export; migration wizard is separate | Masked refresh workflow not established here¹ | Masked refresh workflow not established here¹ |
|---|
| Reusable data masking | Rule dictionary, deterministic seeds + preview playground | Not established in Schema Diff docs¹ | Not established in cited Community feature list¹ | Not established in cited Flyway feature summary¹ | Not established in cited change-automation docs¹ |
|---|
| Safety & governance | Local review gates, dry runs, encrypted credentials | Review generated synchronization scripts | Review generated synchronization scripts | Policy checks + automated deployment controls | Policy checks + governed deployment flows |
|---|