Running the Database Scripts from a Local Directory

This is an alternative method to running the database scripts from Enterprise Designer. You can download the database scripts and run them outside of the Java CAPS environment. Make sure to review the information under Creating the Database Instance, which contains information specific to Oracle and DB2 databases.

The following files are included in the zipped file.

• install_db.bat - Creates the tablespace, users, tables, stored procedures, and any initial values.

• uninstall_db.bat - Drops any database components created by the install_db.bat script (that is, it drops tables and users, and deletes stored procedures).

• database-specific SQL scripts - Scripts that are called by the install_db.bat and uninstall_db.bat scripts (such as create_tables.sql, drop_tables.sql, and so on).

• Readme.txt - Contains additional instructions specific to your database application.

Downloading the Compressed Script Files

In order to work with the compressed script files, you need to export them to a local directory and then extract the compressed files.

To download a compressed script file

1. In the Project Explorer, expand Sum BPM, and the expand Download Database Scripts.
2. Right-click the file associated with the appropriate database (oracle.zip, sqlserver.zip, db2.zip, or sybase.zip).
3. Click Export.
4. Browse to a local folder to store the database files, and then click Save.
5. Navigate to the local folder and extract the compressed files.
6. Follow the instructions in the Readme.txt file.

Running the Downloaded Scripts

Once you download the compressed database scripts and modify them as needed, you can run the scripts from a command line. The database user that executes these scripts must have permission to create tables and users. Review Viewing and Modifying Database Scripts in Enterprise Designer before running the scripts (additional information is also available in the Readme.txt file).

To run a downloaded database script

1. Open a command window and navigate to the directory where scripts are located.
2. Do one of the following:

   • For Oracle databases, enter the following command:

     install_db user password database

   • For Sybase and SQL Server databases, enter the following command:

     install_db user password server database

   • For DB2 databases, enter the following command:

     install_db user password database server

   Where:

   • user is the database username.

   • password is the database user password.

   • server is the name of the machine on which the database resides.

   • database is the database or SID name.

     Note - The default user and password created from these scripts is "bpm6user". You can modify the user, password, disk space allocated for tables, and user permissions. The table and column definitions should not be modified.