export / import the application schema [since
1.5]
Administrative definitions that represent an application
schema can be exported from one OBEROn database and imported into
another. These operations are called "dump export" and
"dump import" and can be performed by a "dump"
OOQL command or directly with the Context Design client. From version
1.5 you can find a Dump menu that allow the following commands:
- export: extracts schema definitions into a
local file
- import: loads some schema definitions from a local file
- compare: compares the database schema definition with those
extracted from another OBEROn database (for example a development
DB) and returns all found differences
- expand: extracts logical connections between administrative
objects
For all these functions you can select the administrative object
types and set a pattern to filter their names before the
related process starts. In other terms you can select which administrative
objects the system has to import/export from/to a file or to compare
or to expand.
Export
Use the Dump Export command to export the definitions
of a OBEROn database.
dump
export feature user,command,menu SR_A*,m* |
|
exportfile
'C:/temp/export_Schema.xml' xml ; |
Admin Objects: are the administrative definition
types to be exported. If you write the OOQL command, you can use
the keyword "all" instead of listing all possible types.
[Right click on the "Admin Object" group title to show
the select/unselect all popup]
Pattern: filters the definition's names to be exported; you
can use the usual "*" and "?" wildcards to indicate
"any number of characters" and "a single character"
respectively.
Full: if activated extracts additional information; this
is not needed to re-generate the schema in a new database instance
or for comparison.
Image: if not activated excludes from the result the icon
associated with the administrative objects. When exporting administrative
objects, the associated icons are included by default.
Feature: if activated extracts also the administrative object
features
File: is the name of a new or existing file to which to write
the export data.
XML: at the moment has no influence for the result because
only XML export are supported.
Append: if activated, appends the export data to an existing
file.
Import
Use the Dump Import command to import administrative
objects from an export file to a OBEROn database.
dump import
feature all * |
|
commit
1 resume
importfile 'C:/Users/Desktop/export_Schema.xml' xml ;
|
Admin Objects: are the administrative definition
types to be imported. If you write the OOQL command, you can use
the keyword "all" instead of listing all possible types.
[Right click on the "Admin Object" group title to show
the select/unselect all popup]
Pattern: filters the definition's names to be imported; you
can use the usual "*" and "?" wildcards to indicate
"any number of characters" and "a single character"
respectively.
Image: when importing administrative objects, the associated
icons are included by default; by deactivating
this option the icon can be omitted. [If the icon was omitted during
the export, it cannot be retrieved from the file during the import]
Feature: if activated imports also the administrative object
features [If the features were omitted during the export, it cannot
be retrieved from the file during the import]
Resume: tells the import process to continue with additional
imports even if an error occurs.
Overwrite: the overwrite option tells the import process
to modify any objects that are found to already exist. Without the
overwrite flag, if an administrative object exists, the import will
fail, since it will try to create a new object with the same name
as an existing object.
Commit: the import process is made under database transactions;
this parameter specifies the number of objects to enclose in each
transaction.
File: is the path and name of the existing file from which
to import the administrative definitions.
XML: sets the import file type as XML
Compare
Compare two schemas to determine the differences between
them. You can use the schema comparison to compare:
Different versions of the same schema to manage changes to
the schema.
Two schemas from different databases so you can merge the
schemas (for example,
merge a development system with a production system).
dump
compare feature menu * |
|
resume
importfile 'C:/Users/Desktop/export_Schema.xml' xml
logfile 'C:/temp/log.txt' ; |
Admin Objects: are
the administrative definition types to be compared. If you write the
OOQL command, you can use the keyword "all" instead of listing
all possible types.
Pattern: filters the definition's names to be compared; you
can use the usual "*" and "?" wildcards to indicate
"any number of characters" and "a single character"
respectively.
Image: when comparing administrative objects, the associated
icons are compared by default; by deactivating this option the icon
can be omitted. [If the icon was omitted during the export, it will
result a difference during the comparison]
Feature: if activated, compares also the administrative object's
features [If the features were omitted during the export, they will
result a difference during the comparison]
Resume: tells the compare process to continue with additional
objects even if an error occurs.
File: is the path and name of the existing file from which
to load the reference administrative definitions.
XML: sets the compare file type as XML
Log: is the path and name of the file where save the comparison
results [optional]
The resultant differences are represented as
OOQL commands to be executed to perform changes into the OBEROn
database, according to the schema definitions read from the reference
file. This represent a fast way to check and to operate upgrades from
a schema to another.
Expand
With this function you can search and extract
all logical connections or interactions between administrative objects.
dump
expand feature form SR_R*
|
|
exportfile
'C:/temp/expand.xml' ; |
Admin Objects:
are the administrative definition types to be expanded. If you write
the OOQL command, you can use the keyword "all" instead
of listing all possible types.
Pattern: filters the definition's names to be expanded; you
can use the usual "*" and "?" wildcards to indicate
"any number of characters" and "a single character"
respectively.
Feature: if activated, extracts also the administrative object's
features
File: is the name of a new or existing file to which to write
the information.
XML: sets the result file type as
XML
Append: if activated, appends the export data to an existing
file.
For each object that satisfies the filters will be
presented a list of administration objects related with it. The
versus indicates if the current object is referenced inside another
(from) or the declaration is made directly in it (to). For example,
a class can have a certain number of fields: if you expand the class
all its fields are indicated with the "to" versus because
the class definition include the field list. On the other hand,
if you expand one of these fields, you can find the class with the
versus "from" because the field is referenced by that
class.
|