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.
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.
A built-in scripting language lets you generate any database-related code. You can access all metadata in your model, including user-defined attributes, or retrieve information from the database catalog using dedicated object-oriented functions. Multiple templates are available, and you can customize them or create your own.
This transforms Xcase™ into a distinctive and potent database programming environment with vast capabilities. Generate DDL and DML code or even programmatically create custom diagrams.
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.
Installed on a Personal Desktop, for one user
i.e $649/year- billed annually
i.e $649/year- billed annually
• Xcase is installed installed on a central Windows PC
• Multiple concurrent users can access it from their own computers
• Each user can be assigned specific modules
• Each user has his own Personal Models Folder, which can be shared with others