xCase Maintenance Features

Purchase

Xcase Maintenance Features

Since a model is composed of very highly interrelated metadata, any modifications you may make in your model will have many implications. For example, when you add a new element to a primary key, it is necessary to create foreign keys, modify or create primary and foreign indexes, modify referential integrity constraints, modify views, modify triggers, etc. Xcase will automatically do this for you within the model. You are not required to be an expert of the database and to know all of the specific details of the often very complex syntax, since Xcase automatically generates all of the necessary code for you. You may then review and modify the code. At the click of a button, the approved code is submitted to the database.

When you modify an object in the Data Dictionary, Xcase:

Modifies Related Objects
Compares Model To Actual Database
Lists Discrepancies
Ports Selected Modifications
Generates Code
Review, Modify and Submit Code
Update at Customer Site
Preserves Existing Data
Automatically modifies all the related objects (indexes, foreign keys, views, fields, triggers) in the model.
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.
Provides a complete list of all of the discrepancies found.
Allows you to select the modifications you want to port.
Automatically generates all of the code required to alter the database.
Allows you to review and modify the code before submitting it to the database while preserving existing data.

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 which is 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

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

Back to Xcase Product Info