banner1

Xcase for Database Evolution Print E-mail
Xcase Evolve-DB is a complete graphical database design tool engineered to help you accomplish all your database-related tasks – from data modeling through to database
modifications – with greater speed, higher quality, and better adherence to current best practices. Its powerful, state-of-the-art automation and graphic features quickly and accurately complete tasks encountered throughout the entire life cycle of your database.

Xcase automatically:
   ERD diagram: click to enlarge
click to enlarge
  • Creates high quality diagrams that document your data model and provide a visual so you can interactively refine the design with team members or customers
  • Generates the SQL code needed to create all the database objects, such as Tables, Indexes, Views, Triggers and Stored Procedures
  • Performs meticulous change-impact analysis and implements the inevitable modifications required by continuously changing business needs – all while preserving existing data
 
  • Overview
  • Highlights
  • DB Life Cycle
  • What’s New

Xcase Evolve-DB Overview

In addition to its advanced functionality for general database design and evolution, Xcase Evolve-DB offers significant technological advantages for IBM i developers and database engineers in several areas:

 True Modeling Environment


Xcase picks up where most other graphical IBM i database tools leave off. It goes far beyond generating static database diagrams and the SQL code used to create and modify objects.

Xcase provides a true modeling environment built around Entity Relationship Diagrams that you use like an interactive blueprint. You can visualize, organize, and quickly navigate even the most complex databases using multiple and embedded diagrams. You modify your model either graphically or by setting properties, without coding. As you work, Xcase transparently finds and updates all related objects for you, behind the scenes. When you're satisfied, it synchronizes the database with your model and generates all of the code needed to implement every explicit and implicit change.


 Documentation for DDS/SQL Hybrid Systems


With Xcase, you can reverse engineer existing DB2 for i databases to create graphical data models, even for databases that contain both DDS-generated and SQL objects. Flexible use of color, fonts and detail within the diagrams allow you to quickly see the relationships between with both types of components so you can make informed decisions.


 Impact Analysis and Change Automation


At the heart of Xcase is the change impact and automation engine that lets you implement any change with increased speed and accuracy. With today’s complex databases, it’s critical to thoroughly and reliably analyze “what if” scenarios for all changes, safe from your live environment. One simple modification can impact Indexes, Views, Triggers, Stored Procedures and Referential Integrity Constraints. Xcase shows you the scope of any change, lets you decide what you want to implement, and then automatically generates the code you need. Throughout the entire process, Xcase tenaciously preserves your existing data.


 Database-Embedded Validation Logic


Traditionally on the IBM i and AS/400, programs dictate data validation and referential integrity rules. With SQL, these business rules reside in the database, so the system automatically ensures that they are enforced at all times. SQL’s built-in data integrity increases database performance as well as the integrity of your data. Plus you will not have to spend time writing rules into new applications.

Xcase helps you transition your data validation logic from your programs into your modernized database. Working within the graphical data model, you can easily visualize relationships and then define your business rules, such as relationships between tables (referential integrity constraints), primary and unique key constraints, and column-level (or check) constraints. As you work, Xcase automatically generates the code for the Triggers and Stored Procedures needed to safeguard database integrity.


 Validation of Business Rules


When business needs require you to introduce new validation rules for your data, you must ask “Is my existing data compatible with this rule?” Xcase gives you the answer quickly. It checks record relationships, unique keys, fields and records to see if your existing data will match new business rules. It then generates a report on all data integrity errors found. You can then address these issues in one of two ways. Xcase will show you the physical data and let you edit it or, for large quantities, Xcase will generate SQL statements to identify all records with the same problem so you can fix them programmatically. Either way, Xcase makes it easy to access and update “faulty” records to restore data integrity in light of planned changes.


 View and Edit Physical Data


Xcase provides a direct link from the conceptual domain into the physical data. When the time comes to test the database model and the related Triggers, Constraints and Views, Xcase gives you full relational navigation using automatic parent/child browsers and lookups. You can quickly navigate through the database checking for relational and data integrity, as well as the validity of business rules. For example, by opening a Table to view its physical data, a completely configurable browser appears showing the selected parent in the top pane and a list of the children on the bottom pane. You can drill down to any level of detail. Xcase’s extensive features for viewing and editing data also facilitate proof of concept and demonstrations to end users to gather feedback.


 Built-in Version Control


You never have to worry about over-writing important code with Xcase. Xcase keeps track of all previous versions of your database model so you can see the differences on demand and go back to a previous version whenever necessary. In addition, its automated synchronization process compares a modified model to any previous version, produces a detailed report of all discrepancies found, and lets you selectively choose the changes to apply.


 Code and Object Generation


With Xcase, you do not have to know SQL to build physical database objects, intricate data validation rules, or elaborate reports. Xcase automatically generates the code you need to create and maintain sophisticated Triggers, Stored Procedures, Constraints, Tables, Indexes, Views and Queries. More importantly, you do not have to write a single line of code to maintain those complex SQL statements. When you inevitably change field names, drop fields, modify keys, or make other necessary changes to your database model, Xcase will automatically find all of the related SQL objects and update them for you. It painstakingly preserves the ongoing integrity of even the most complicated Join Views.


 Attention to Detail


All SQL dialects are not created equal. Therefore, tools that provide generic SQL support are simply not adequate for unique environments like the IBM i. Xcase is different. It provides unmatched support for IBM i SQL. With Xcase, you can set and modify attributes such as Record Format, compilation parameters, CCSID and many other attributes specific to this unique, reliable platform.


Take advantage of this new power. Evolve-DB helps you safely and quickly make important database changes that will significantly improve application performance by transparently and reliably handling all of the tedious and time-consuming implementation tasks.

Xcase Evolve-DB Highlights

Xcase offers exceptional value to database engineers who want the power and automation of high-end DB solutions - without the expense or high-overhead enterprise collaboration options. Here’s just a sampling of how Xcase simplifies success for DB engineers.

Unique embedded diagrams

Control how much detail you see in each ERD. You can embed related ERDs and drill down by double clicking. See it >>

Consistent, flexible editors

Learn Xcase quickly. Edit all objects via a consistent, highly customizable dialog that gives you quick access to all the info you need. See it >>

Data integrity checks AND fixes

When you modify business rules, only Xcase goes beyond checking for data integrity. It shows you the actual data that violates your new rule so you can fix it manually or programmatically . . . with the help of Xcase, of course. See it >>

View/edit data relationally

For fast, easy testing, Xcase gives you hands-on access to physical data. Edit it using drop-downs or look-ups then navigate through related tables to view results, all without ever opening the application. See it >>

Advanced auto layout of ERDs

Xcase creates quality ERDs fast by analyzing the entities and relationships you’ve defined and automatically organizing them into the most effective presentation. Select your choice of Hierarchical or Orthogonal styles. Xcase uses sophisticated incremental layout to preserve your "mental map" when you add or delete objects or modify display options. See it in action>>

Easy two-way synchronization

Confidently evaluate “what if” scenarios within your model. Xcase compares your database to the model and allows you to selectively apply modifications to the database or to the model - the ultimate selective Undo feature. See it >>

Smarter scripting language

Hidden until needed, power users thrill at the flexibility and ease of use of Xcase’s uniquely impressive scripting language. This allows you to customize the scripts generated by Xcase to create or alter database objects or to create virtually any database related script.
See it >>

Customizable Metadata

In addition to mapping all the relevant metadata of your target database in your model, Xcase allows you to easily add your own metadata. These user defined attributes are seamlessly integrated into the editors and can be accessed by the scripting language. This feature grants unprecedented flexibility to the power user. See it >>

Automatic Model Maintenance

The information in a database model is highly interrelated. A small modification can have a profound impact on many objects. Xcase automatically handles this by propagating the modification where needed. See it >>



Xcase and the Database Life Cycle

If you’re like most database engineers, you crave a work environment that gives you the agility and the stability you need — one that strikes the perfect balance between power and ease of use — one that makes success simple to achieve.

Database engineers come to rely on Xcase to accurately speed them through detail-driven tasks throughout the entire life cycle of the database application. At every turn, Xcase simplifies your work by taking care of the tedious and time-consuming details that can slow you down.

 Design / Reverse Engineer


Watch the demo

Xcase offers a highly sophisticated visual interface that allows you to accurately design your database by capturing every detail about your company’s or customer's business information world. The automation and maintenance mechanisms provided by Xcase assist you in accomplishing the analysis and design of the database completely and with integrity. No need to be an expert on the databases with which you work. Xcase, your database expert, handles the details while you focus on the design of the database.

Reverse/Forward Engineering

Transform your existing databases into presentation quality diagrams in minutes. Diagrams show both DDS and SQL components.

Graphic Features

Comprehensive graphical features visually manage complexity with organized, easy-to-understand Entity Relationship Diagrams (ERDs)

Customization

Access and edit all meta-data attributes (including your own) using customizable Browsers and Attribute Inspectors. Xcase’s customization capabilities offer additional flexibility for novices and power users alike.

  • A fully customizable Data Dictionary which allows you to include user defined attributes.
  • Powerful and customizable editors to easily access all the pertinent attributes in the database.

Automation

Accurate, time-saving automation mechanisms speed the design process with Xcase.

  • Automatically defines of foreign keys as you create relations.
  • Automatically builds primary indexes as you flag primary keys.
  • Automatically builds foreign indexes as you create relations.
  • Automatically cascades modifications in the parent field to the children fields.
  • Regardless of whether the target database supports domains, when you create a domain, the attributes of the domain will automatically be propagated to the fields which you assign to the domain.

Inheritance

Modifications of a field attribute or a domain attribute can be automatically propagated according to the user defined inheritance mechanisms you have set when the modifications must be propagated to foreign keys, view elements, index elements.

Validity Checks

Xcase thoroughly checks to ensure the validity of your design.

  • Automatically checks the correctness of database object names according to the rules of the target database.
  • Automatically checks and signals if you have defined redundant indexes.


 Present


Watch the demo

Once you have completed the design of the database, Xcase produces high quality diagrams that allow you to present your design from different views and with various levels of detail. By allowing you to customize the presentation for your customer, your colleagues or for your own use, Xcase greatly facilitates the iterative process of analysis, design and presentation.

Full Graphical Control

Your choice of colors, fonts, annotations and graphical objects gives you full control over the presentation of your ERDs.

Graphical Management of Relations

Quickly and clearly identify the outgoing relations of a table by automatically setting the color of the outgoing relations to match the background of the parent entity.

Multiple Diagrams

Divide your ERD into manageable sub-sets of the entities and relations with Xcase’s support for multiple diagrams.

Embedded Diagrams

To more easily understand complex databases, you can embed a diagram within a base diagram. Double click on an embedded diagram to display their entities and show the relations between those entities and the entities of the base diagram.

Multiple Displays

Multiple stored displays of each diagram present the objects contained in the ERD at varying levels of detail.

Context-Driven Navigation

  • The Xcase Navigator allows you to see your complete work space in a small window in order to easily locate the displayed diagram within the context of the whole.
  • A tree allows you to easily find and access database objects.
  • A zoom window displays normal scale views of sections of a zoomed out display.

 Document


Watch the demo

Once you have completed the analysis and design of your model and have presented your design to your customer, it is important to fully document your design, the blue print of your application. Xcase automates this tedious and time-consuming task, allowing you to easily print diagrams and customized reports with comments as well as your own user defined attributes.

Presentation Quality Graphical Documentation

  • Full color printout of diagrams
  • Export diagrams as Windows Meta Files or Enhanced Meta Files
  • Customers can use the Xcase Viewer (purchased separately) to view, but not modify, the complete model

Multiple Reporting Options

The Crystal Reports engine shipped with Xcase produces presentation quality reports in a variety of formats, including RTF and HTML, which may be published directly on your Web site.


 Generate


Watch the demo

At this point you've refined your original design according to customer feedback and you’re ready to generate all the database related code. Xcase automatically and reliably generates all of the code needed: Data Definition Language Code to build the database, Triggers and Stored Procedures to safeguard data integrity, and Object Oriented Code to provide all of the important metadata for the front end of your application. And when it comes to Views and Queries, Xcase has the unique ability to automatically create and update even complex SQL statements - without human intervention.

Superior Scripting Language

At the heart of Xcase lies an extremely powerful TCL-based scripting language that is actually easier to learn and easier to use than the lesser macro constructs provided by other tools. Xcase’s scripting engine generates all database-related code, such as XML schemas, and gives you full access to all of the metadata information, including user defined attributes, both in the Xcase Data Dictionary and in the Database Catalog.

DDL Code for Database Structure

Xcase generates accurate DDL (Data Definition Language) code to physically build the basic structures such as tables, indexes, etc., required to hold data.

Referential Integrity Code

Xcase transforms the business rules specified in your model into Triggers, Stored Procedures and Constraints that reliably safeguard and enforce referential integrity when users input data.

Code to Extract Data via Views and Queries

Modern databases often contain complex relationships. Xcase "knows" its way around your model and intelligently combines series of relations into "paths," greatly facilitating the definition and maintenance of SQL Views. You can accurately extract relevant data from the database without having to write a single line of code, even for complex SQL statements. In addition, when you change field names, drop fields or modify keys, Xcase maintains the code without fail.

This unique and extremely valuable feature is not offered by any other product on the market.

Object Oriented Code

Xcase builds object oriented code specifically for the target application to provide all of the important metadata required to manipulate the databases. For example, it automatically generates data modules for Delphi from selected entities and views in Xcase and incorporates them into the Delphi project. Not only is this a powerful, time-saving feature, but it ensures consistency and integrity since attributes, validations, etc. are automatically drawn from the same source, the Xcase metadata.


 Manage Data


Watch the demo

One of the most striking Lower CASE features offered by Xcase is that it provides a direct link from the conceptual domain into the physical data by allowing database engineers to move physical data from one database to another, then relationally view the data and edit it with integrity . . . all from within Xcase. Perfect for testing proposed changes to your database.

Automatically Validate Physical Data

  • Check that data in your database conforms to the constraints defined in your model
  • Check relations to verify:
    • That there are no orphan records
    • That there are no orphan records
    • That at least one child exists for a relation defined as "0 Not allowed"
    • That only one child exists in a 1-to-1 relation
  • Check uniqueness to verify that keys in the database are unique for primary keys, alternate keys and unique indexes as defined in the model
  • Check fields and records to verify
    • That fields defined as "Not Null" in the model do not contain Null values in the database
    • That enumerated type fields only contain valid values
    • That fields and records comply with the rules and constraints defined in the model
  • Produce detailed reports on all the data integrity errors found
  • View and edit the "faulty" data in dedicated browsers that allow you to "fix" data integrity errors

View and Edit Data

Towards the end of your database development, even before creating the final application, Xcase makes it easy to test all aspects of your design.

  • Test Rules
    Test the model, particularly the associated database-related code such as triggers, constraints and views, without leaving the Xcase environment.
  • Demonstrate Model
    Developers can more effectively demonstrate an essentially abstract and conceptual model by showing the user the physical data.
  • Input Data
    Customers can input data before the final application has been completed. They not only avoid "wasting time" waiting for the final application to begin inputting data, but customer satisfaction is secured by providing a working model at the early stages of development.
  • Test Model
    Customers can test whether the design of the database has been accurately and completely structured to meet their requirements. By testing the validity of the structures and business rules, the customer may provide feedback on whether the model includes all of the fields and tables, as well as on the accuracy and suitability of the business rules.
  • Prototype User Interface
    Customers can help direct the development of the user interface by providing feedback on how to best organize the data on screen. Because the browsers are readily configurable, he can effortlessly arrange the data as he chooses. The customer may also determine how he wishes to access data by easily designing queries for which Xcase will automatically generate ready-to-use SQL code that may then be incorporated into the database by creating views or by simply integrating them into the final application as queries.
  • Maintain Data
    Developers have direct and easy access to every piece of data in the database in order to perform maintenance operations with integrity. This is a very powerful maintenance feature since, in general, data is only partially accessible in the final application.

Full Relational Navigation for Viewing/Editing Data

  • By opening a table to view its physical data, a completely configurable browser appears listing the children on the bottom pane of the selected parent in the top pane.
  • You can view all of the children for the different relations outgoing from the parent table.
  • At the click of a button, you can drill down into the children on the top pane of the browser, or see the grandchildren of the original parent record on the bottom pane.

Automated Editing Features

  • While editing data, look-ups are automatically set for each foreign key.
  • It is possible to set fields for enumeration in the Xcase Data Dictionary so that when editing a field, a drop down will appear.

Automatically Port Data

When you need to convert your database from SQL to Oracle, SQL Server to MySQL, and so on, Xcase Evolve-DB automates the process for you.

  • Xcase creates a new model for a new target database based on a model previously created for another database, automatically executing at model level all of the necessary transformations such as translating data types.
  • Xcase automatically recreates the data for the new target database based on the existing data from the original database.

 Maintain


Watch the demo

No matter how good your original database design, business demands will require it to change. Again, Xcase is your invaluable assistant, automatically maintaining metadata in both the model and in the Database Catalog. Once you have made necessary modifications, Xcase allows you to automatically update the database at the customer site while preserving existing data.

Models contain highly interrelated metadata. That's why any change you make may have wide-ranging implications. For example, adding a new element to a primary key requires you to create foreign keys, modify or create primary and foreign indexes, modify referential integrity constraints, modify views, modify triggers, and so on.

Using Xcase, you don't have to be an expert in the database or to know the details of the often very complex syntax. Xcase automatically handles all implications of a change for you within the model and then generates all of the necessary code for you. You then review the code, modify it if you want and, at the click of a button, submit the approved code to the database.

More specifically, when you modify an object in the Data Dictionary, Xcase:

Modifies Related Objects

Automatically modifies all the related objects (indexes, foreign keys, views, fields, triggers) in the model.

Compares Model to Actual Database

Performs a thorough comparison of all of the attributes of all the database objects as they appear in the model and in the actual database by comparing the model to the actual database, and not to an archived version of the model as some other products do.

Lists Discrepancies

Provides a complete list of all of the discrepancies found.

Ports Selected Modifications

Allows you to select the modifications you want to port.

Generates Code

Automatically generates all of the code required to alter the database.

Review, Modify and Submit Code

Allows you to review and modify the code before submitting it to the database while preserving existing data

Update at Customer Site

For Local Databases (VFP and Jet), Xcase provides a free for distribution run time module that compares the Xcase Data Dictionary with the actual database and updates the database at the customer site while preserving existing data.
For Server Databases, the Xcase Viewer (purchased separately for installation at the customer site) provides:
  • The capacity to compare the Xcase Data Dictionary with the actual database and update the database while preserving existing data
  • Extremely flexible documentation of your design
  • The capacity to view and edit data and design queries

Preserves Existing Data

When the modification of an attribute of a table cannot be implemented via the "Alter" command for a specific database, and you wish to preserve existing data, Xcase automatically:
  • Creates a temporary table with the updated structures and attributes
  • Moves all of the data from the existing table into it
  • Drops the previous table
  • Designates and renames the temporary table as the original table


What's New in Xcase Evolve-DB

 Version 9.1


Display Schema/Owner (Enhancement)

When a model includes objects from different schemas or owners, this can be displayed as a qualifier of the object in the display and in the tree. To set this for the current display, in the Display Settings dialog, check "Display Schema/Owner". To set the default behavior for newly created displays, select Options, Settings and in the Display Tab check "Display Schema/Owner".

Display non PK Parent (Enhancement)

When selecting to display Keys, columns that are not PK but parents in a Relationship (AK, Unique Index) are now displayed.

New Columns in Views (Fix)

When a column is added to a table and a View is defined on the Table as "Select All", the new column now appears in the "Column Editor" list of columns.

Drop Stored Procedures (Fix)

The script produced to drop from the database Stored Procedures not found in the model has been corrected. It used to be empty.

Dropping Objects not in Model (Fix)

When Tables where not selected in the Sync dialog, and "Check objects not found in the model" was checked, Tables, Stored Procedures, Functions and Views not in the model where not displayed.

Displaying Hidden Relationships (Fix)

When displaying hidden relationships, the layout algorithm is executed if Automatic Layout is selected.

Action Column Size (Fix)

In the Sync dialog the size of the Action Column has been increased so that its content is fully displayed.


 Version 9.0


Automatic Layout

Xcase can automatically layout your diagrams using Orthogonal or Hierarchical layouts. You can also set that the display will be automatically arranged when you modify the contents of the display or add new objects. Watch the demo

New Views Dialog

The interface allowing to define or modify Views has been completely revised. A new combined dialog allows you to conveniently view and edit all the view attributes at the click of a button. In addition the generated SQL statement is now visualized in the dialog and is dynamically modified as you change view attributes. Watch the demo

Naming Conventions

You can now better control the naming conventions of the objects created in the model. The object names can be set using templates which can use all the attributes in the model. Watch the demo

Modified Reverse Engineer Dialog

When reverse engineering objects you can now select specific Entities, Views, Functions and Stored Procedures Watch the demo

New display Tabs

The currently open displays appear as Tabs on top of the display window Watch the demo

Add Related Entities

When you right click an Entity in a Diagram, you can now select "Add Related". This will add to the diagram all the parent and children of the selected entity. Watch the demo

Sending a model via mail

You can now send a model archive via e-mail Watch the demo



 Version 8.1


Support for Multi Attribute Form in the Browser Bottom Pan

The bottom pan of a browser can now display Multiple Tabs (each displaying a single attribute) or a Multiple Attribute Form (similar to what existed in previous versions of Xcase). This can be set in the General Tab of the Settings dialog accessible from the Options menu.
To modify the layout of the Multiple Attribute Form, click the "Form Design" icon in the Browser tool bar. In design mode, you can move and resize attributes. In addition, right clicking an attribute or an empty space in the form will produce menus allowing the customization of the form.

Disabling Gradients when Printing to Printer or PDF

When printing diagrams to PDF using the Adobe PDF printer the produced PDF is incorrect. Using the CutePDF Writer (shareware edition available on the Net) fixes the problem. This can also happen when printing via some printers. You can now disable gradients when printing, by un-checking this option in the General Tab of the Settings Dialog accessible from the Options menu.

Selecting "All in Diagram" when Synchronizing DB to Model

In the Sync dialog, when selecting embedded diagrams, the entities included in embedded diagrams are now also selected.

Indicating that an unselected tab in the bottom pan browser has content

When the bottom pan of a browser displays multiple tabs, the color of the tab now indicates if it has content.



 Version 8.0


Redesigned Relational Integrity Logic

When creating a New Model, the Model Settings Dialog allows defining the Referential Integrity Implementation. This determines the default Referential Integrity implementation at Model level, and can be overridden at relation level in the Referential Integrity dialog box, available from a right-click on a relation.

Redesigned Workspace

The workspace has been completely redesigned in order to make it consistent with the XP look.

Redesigned customizable and powerful XP style Toolbars

The Toolbar has been redesigned in the XP style. It comprises the following groups of tools, File, Edit, Database, Model, Display, Zoom, Adjust, Shapes.

New Main Menu Structure

The Menus have been enhanced and re-organized into more logical units.

New Multi-select Ability in the Synchronize and Merge Dialogs

In the Sync and Merge Dialogs, it is now possible to select multiple discrepancies in the displayed list. It is then possible to apply an action to all the selected items at once.

Redesigned Browsers & Inspectors

All browsers and inspectors have now been logically regrouped in multi-tab specific Browsers, so that all the settings relevant to a given task can now be performed without having to go back and forth between menus and Browsers.

Redesigned Physical Data Browser

The Physical Data Browser has been completely redesigned. For each Parent Entity in the upper pane, it now shows all the Child Entities in a tabbed browser in the lower pane.

Easier handling of the Message Log Window

Clear and Show Messages accessible from the Window menu have now been regrouped into a single Message Log window.

Redesigned Dialog boxes

All the Dialogs have been redesigned in the XP style. Some Dialogs have been split in order to have a clearer view of the various actions and more logical groupings.

Redesigned Xcase Help

The Xcase Help System has undergone a complete update. It now uses the compiled HTML Help format. Many screen shots and pictures have been added to make it more intuitive and efficient. The text has been revised to make it even more clear and concise.

New Select Data Dictionary Object

This new feature allows selecting Data Dictionary Objects Names in the Code Editor. If you are in the middle of typing an Entity or View name, or a qualified column name, pressing F3 will allow you to select it in the Dialog and it will be auto-completed.

New Align feature

The Align opens a dialog box that allows you to align all the selected Entities horizontally and vertically in addition, it includes a space equally function.

New Dynamic Zoom

The Dynamic Zoom Tool allows you to increase or decrease the zoom level of the display by clicking the left mouse button and dragging it on the workspace.

New Fit to Program Window

This function fits the current diagram to the Program Window. This is much more efficient than using the usual Maximize or Tile standard features, without their drawbacks.

New Fit to Window

This function re-sizes the entire Display to have it fit in the Display Window. If a Marquee is active when you click the Fit to Window button, it will apply to the Marquee rather than to the whole Display.

New Hand Tool

The Hand tool allows you to easily grab and move the display around to focus on the part you are interested in.

New Hotkeys

Hotkeys is a new feature allowing to execute common commands by pressing a single key.

New Make not-null Bold

This option of the Display tab in the Settings dialog allows you to emphasize fields that cannot be null by having them displayed in bold within the Entity.

A New Diagram

You can now create a new diagram based on the current one by right-clicking on an empty space and selecting the New Diagram option from the pop-up menu.

New ODBC Setup

Clicking the Synchronize Database with Model option, opens the Connect to ODBC Source, this now features a Setup button that opens the ODBC Data Source Administrator from within Xcase.

Redesigned Reports

The listings of the data dictionary objects in Model Reports have now a Comments column. In addition, if the descriptive name (title) of an object differs from the physical name (name), it will be displayed after the name.

New Display Settings

This option accessible from the View menu opens a dialog box that allow you to easily set modify the settings of the Display. The dialog can also be closed by clicking the Display icon. Their Defaults can now be set.

New Straighten Line

This function is available when you right-click on a relationship connecting line between two entities. It automatically straightens the line instead of you having to try to drag it to the required position.




Online Demo

Take a look at how easy it is to accomplish all of your database design and evolution tasks with Xcase. Learn More...

Xcase Trial Edition

Experience the power of advanced DB design and modeling designed especially for SQL on i.Get It Free...

Contact Us

Call us: 866.467.4487

Request a Quote

Ask a Question

Evolve-DB Functionality

Key Xcase Functions
Supporting Database Evolution


  • Creates graphical data models; reverse engineers existing databases
  • Documents database design, even for DDS/SQL hybrid databases
  • Performs impact analysis for changes
  • Generates DDL code to build or change the database structure
  • Generates Triggers and Stored Procedures to safeguard data integrity
  • Generates Views and Queries to extract data
  • Validates data against business rules and constraints
  • Identifies faulty data subsets; helps restore data integrity
Learn More...

Database Normalization

Xcase can help you easily reveal the many relationships that currently lie hidden within your DB2 for i database. Improve DB performance, documentation, data integrity and support for Web Query.Learn More...