The “generateModel” command generates the SQL script to install ImageMaster into an empty database. It requires no database access (which means the -t option can be used instead of providing a JDBC URL and driver jar file).
Without further parameters, the command outputs a script to install ImageMaster without partitioning. The script will contain placeholder variables for the tablespace and indexspace to use. The output is essentially the same as the installation scripts provided in the “db-model” folder of the ImageMaster distribution.
Further parameters are available to control tablespaces and partitioning:
|
Parameter |
Description |
|---|---|
|
-t <tablespace> |
Specifies the name of the tablespace for (unpartitioned) ImageMaster tables. In the context of Microsoft SQL Server, this parameter refers to the filegroup to use for table storage. |
|
‑‑tablespace <tablespace> |
|
|
-i <indexspace> |
Specifies the name of the tablespace for (unpartitioned) ImageMaster indices. In the context of Microsoft SQL Server, this parameter refers to the filegroup to use for index storage. (If only the -t parameter is provided, then that tablespace will be used both for tables and indices.) |
|
--indexspace <indexspace> |
|
|
-s <file> |
Specifies the table storage definition to use for the generated SQL script. A table storage definition is an XML file with the schema, see |
|
--storage <file> |
|
|
--partitioning <file> |
|
|
-a |
Enable all database model options in the generated script. See Optional changes in the database model. |
|
--all |
|
|
--options <option list> |
Enable the specified database model options in the script. The options must be provided as a comma separated list. See Optional changes in the database model. |
|
--execute-immediately |
If specified then the tool directly executes the SQL commands through the JDBC connection of the database. |
|
Table 427: generateModel command |
|