Administering the Sun Business Process Manager Database

Running the Database Scripts

Before running the database scripts, make sure you have a database instance running and have reviewed the information under Creating the Database Instance and Viewing and Modifying Database Scripts in Enterprise Designer. The connectivity information must also be configured for the scripts.

ProcedureTo create the database tables

  1. In the Project Explorer, expand Sum BPM, and then expand Run Database Scripts.

  2. Right-click the file associated with the appropriate database (Oracle Install, SQL Server Install, DB2 Install, or Sybase Install).

  3. Click Run.

ProcedureTo drop the database tables

  1. In the Project Explorer, expand Sum BPM, and then expand Run Database Scripts.

  2. Right-click the file associated with the appropriate database (Oracle Uninstall, SQL Server Uninstall, DB2 Uninstall, or Sybase Uninstall).

  3. Click Run.