Running Database Scripts Automatically

You can choose to run the database scripts automatically when you deploy a Project to a server. Scripts can be automatically run for both the monitoring and recovery database and for the Business Process reporting tables.

To run the scripts automatically

1. Create the database instance, as described in Creating the Database Instance.

2. Modify the monitoring and recovery database scripts and define the database connection properties, as described in Running the Scripts in Enterprise Designer (but do not run the scripts).

3. Configure the Business Processes in the Project for persistence and configure the database connection properties (but do not run the scripts).

4. Configure the Sun BPM Engine for persistence. Set Automatic Execution of Database Scripts to true.

5. When you deploy the Project, the scripts are run automatically for the monitoring and recovery database and for each Business Process configured for persistence.