You can create the database schema script using the gen-create-schema Ant task.
To create the SQL script required to create or update the database schema, run the gen-create-schema Ant task with these parameters:
-Dserver.url=<server url>
-DdatasourceName=<data source name>
-DextensionModel=<model file>
The model description (.brmx extension).
-DextensionData=<data file>
The model data description (.brdx extension).
[-DdbSchemaName=<database schema name>]
An optional parameter that can be used to specify the database schema name in which the Decision Center tables are stored. Decision Center uses the database user name as the schema name if this parameter is not specified. However, some databases allow for a given user to access several schemas, and the default schema is not always named the same as the user.
[-DoutputFile=<SQL file>]
The name of the file that stores the generated SQL script. If this parameter is not given, the task creates a file named output.sql in the directory defined as basedir in build.xml.
For example:
ant gen-create-schema -DextensionModel=my_model_file.brmx -DextensionData=my_data_file.brdx -DoutputFile=my_sql_file.sql
The task connects to the given data source from the application server. The task checks if this data source points to an existing Decision Center database. If a database does not exist, the task builds the SQL script to create a fresh database schema to store the model. If a database does exist, the task builds the SQL script required to update the existing database schema.