Xcase is a complete database design tool
engineered to help you accomplish all your database-related tasks from data modeling through to database maintenance,
with greater productivity and higher quality.
|
Maintain your DB
Reverse Engineer existing databases into presentation quality diagrams in minutes.
Change your model design to meet you company’s evolving IT needs or requests from clients that constantly change the database design.
Present clear data models at various levels of detail using visual objects, colors and embedded diagrams to organize database schemas.
Synchronize your model with the database using the 2-way synchronization feature. Compare a model to the actual database (or to another model) and selectively choose the changes to apply from a detailed report of all discrepancies found.
Generate code using a powerful automation module based on fully customizable templates. Xcase assists you in generating all the database related code including:
DDL Code to build and change the database structure
Triggers and Stored Procedures to safeguard data integrity
Views and Queries to extract data
|
|
Design new Databases
Draw ERD diagrams and design database structures using a sophisticated visual and intuitive interface.
Document your design using multiple reporting options. Xcase allows you to easily print diagrams and reports. You can add comments to the reports and include your own user defined attributes to the model.
Generate all the SQL code necessary to create your database automatically.
Migrate
Port database structure and data from one DBMS to another. Xcase will automatically execute all the necessary transformations at the model level and recreate the data on the new target database.
Manage Data
Validate the data in your database against the business rules and constraints defined in the model and generate detailed integrity reports.
Access and edit the data relationally using automatic parent/child browsers and lookups.
Locate faulty data subsets using automatically generated SQL statements.
|
To find out for yourself,
Download a trial version of Xcase and
click
Demo to see Xcase design and maintenance capabilities in
action.
|
