Database design and governance: Evolve™

Design the change. Ship the change.

Author and evolve the model: add tables, columns and relationships on the diagram, then synchronize - Xcase writes and submits the DDL.
Keep model and database honest: integrity checks that find the broken rows your constraints never caught, with the SQL to locate them and in-place fixes.
Version your schema like source code: archive, compare and merge models, and commit them to Git as JSON.
Migrate to a different DBMS: change the target and Xcase re-maps types and copies the data.

Download a free trial

Includes Xcase Core. Evolve adds the authority to create and modify model metadata and to generate and synchronize from your own changes - including through scripts.

Assisted design: model changes synchronized to the database

Make changes directly through property settings—no manual coding required. Instantly generate code for objects like tables, views, constraints, indexes, stored procedures, and triggers with just one click.
All dependent objects update automatically when column names or keys are modified.
Two-Way Synchronization Process: You can compare your database with your model. Xcase™ will generate a detailed report at the object/attribute level, outlining the differences found. Then, you can select specific actions to address each discrepancy by automatically generating a script to modify the database or by reverse engineering it into the model.

Data integrity checking with generated SQL and in-place correction

When defining constraints in the model, your database might not meet them. It's essential to identify which records violate these constraints so you can correct them.
Xcase™ automatically detects violations and displays the offending records, allowing you to fix the issues either manually or programmatically using the automatically generated SQL statements that retrieve them.

Model version control: archive, compare, merge

This guarantees reversibility while keeping complete control over your data model’s development.
Compare model versions, spot differences, and choose to implement or undo changes selectively.
You can use the built-in version control system or export and import your model in JSON to work with your existing versioning system.

Git integration through JSON model export and import

Export any model as structured JSON and commit it to Git - or any version control system your team already uses. The exports diff cleanly, so model changes get reviewed like code changes; importing a JSON model restores it completely.

Your schema's history, next to your source code.
Pairs with Xcase's own model version control for archive, compare and merge.

Migration to a different target DBMS with generated DDL

Change the target DBMS and Xcase re-maps every data type for the new platform, copies the data, and writes the DDL for the target. The structure and the rows make the trip; the generated DDL is yours to review before anything is created.

Type-by-type mapping for the new platform - no manual translation table.
Data copied into the new structures, ready to verify with a browse.

Stored procedure and trigger generation from customizable templates

Generate stored procedures and triggers from templates that know your model - its tables, keys and relationships. Use the shipped templates, customize them, or write your own; what comes out is plain source code you review before it ships.

Repetitive database code produced consistently, from one template.
Template changes propagate: regenerate and every object follows.

Metadata-write scripting operations

Evolve extends Xcase scripting with write access to the model: scripts can create and modify tables, columns, relationships and other metadata, turning repetitive design work into a repeatable, reviewable operation. Reading metadata is part of Core scripting; writing it is Evolve's authority.

See Evolve in action