Generating SQL database scripts using the BPMConfig command
You can use the BPMConfig command to generate the database scripts that are used to create your database tables. If you used the BPMConfig command to create the stand-alone profiles and database tables, the scripts were generated for you.
Before you begin
Prepare the following information:
- Information about the database configuration that you are designing.
This might be a document that describes the general purpose of the
database configuration supplied by the database administrator or solution
architect. Alternatively, it might be a description of required parameters
and properties. This information must include:
- The location of the databases.
- The user ID and password for authenticating to the database.
- Information about how IBM® Business Process Manager and its components have been installed, the database software used, and the properties required by that type of database.
- Information about the topology pattern to be implemented, and an understanding of how the database design fits into the pattern that you plan to use.
Procedure
To generate the database SQL scripts that you can use to create your database tables, complete the following steps:
Results
The database SQL scripts are generated in the STAND-ALONE_PROFILE\dbscripts folder by default. This folder includes the following sub-folders:
- cell_name.deployment_environment_name - For each deployment environment, this folder will contain the SQL files that need to be run.
These subdirectories also contain a createDatabase.sql script, which you can use to run the database scripts to create the SQL Server database tables.
A
default configuration for an Express deployment environment with SQL
Server databases contains the following sub-folders and SQL scripts:
- cell_name.deployment_environment_name
- SQLServer
- CMNDB
- schema name
- createSchema_Express.sql
- createSchema_Messaging.sql
- schema name
- BPMDB
- schema name
- createSchema_Express.sql
- createProcedure_Express.sql
- schema name
- PDWDB
- schema name
- createSchema_Express.sql
- schema name
- CMNDB
- SQLServer