|
Maintain
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
| 
