In addition to directly installing a schema, you can also use the Schema Tool to create an MQL installation script for later use. For this you use a task called create-install-script. This task works exactly like the install task, except it will not update the database; instead it will write all MQL commands to a local file. It supports the following attributes:
Table 2. Installation script
Attribute |
Description |
Required |
readonlyattributes |
A comma-separated list of attribute names whose values should NOT be updated/modified when installing. Symbolic names are NOT allowed. The default attribute names are: eService Next Number and TVC Number. |
No |
The following nested elements are supported:
To define where the schema is located you add a nested schema element.
To define how to connect to the database you add one of the server or database nested elements.
To define that only items in files modified after a certain date should be installed you add the optional modifiedafter element.
For example, the following definition will connect to ENOVIA as 'creator' via a web server at localhost listening to port 8080. It expects to find the eMatrixServletRMI.jar file in the lib directory. It also specifies that an alternate JDK should be used while installing the schema. Note that the <javahome />
and <memory />
elements are optional.
<schema:create-install-script>
<schema location="schema" />
<output location="install.mql" />
<server host="http://localhost:8080/enovia">
<user name="creator" password="" />
<classpath>
<pathelement location="lib/eMatrixServletRMI.jar" />
</classpath>
<javahome location="C:/apps/jdk/6u45" />
<memory size="small" />
</server>
</schema:create-install-script>
The following example will directly connect to the ENOVIA database using the specified ENOVIA server installation and bootstrap file. Note that the <javahome />
and <memory />
elements are optional.
<schema:create-install-script>
<schema location="schema" />
<output location="install.mql" />
<database enoviahome="C:/apps/enovia/V6R2010x/server" bootstrap="boots/MATRIX-R">
<user name="creator" password="" />
<javahome location="C:/apps/jdk/6u45" />
<memory size="small" />
</database>
</schema:create-install-script>