Creating a Microsoft SQL Server database for Business Process Choreographer

Use this task to create a Microsoft® SQL Server database for Business Process Choreographer.

Steps for this task

  1. Install an SQL Server, on the server that hosts the database. Make sure that you select the option to create a case-sensitive instance. If you already have an SQL Server that was created with the case-insensitive option, run the rebuild master tool and change the collation settings to case-sensitive. Make sure that the server supports Unicode.
  2. Make sure that the database server and that the Distributed Transaction Coordinator (DTC) are running.
  3. On the server that hosts your application server, change to the directory where the configuration scripts for Business Process Choreographer are located:
    • On Windows® systems, enter:
      cd install_root\ProcessChoreographer
      On UNIX® and Linux® systems, enter:
      cd install_root/ProcessChoreographer
  4. If your database is not on the same server as your application server:
    1. Copy the DDL scripts for your database from the ProcessChoreographer directory on your application server to a suitable directory on the server that hosts your database:
      clearSchemaMsSql2000.ddl
      createDatabaseMsSql2000.ddl
      createSchemaMsSql2000.ddl
      dropSchemaMsSql2000.ddl
    2. Change to the directory where you copied the DDL scripts.
  5. Perform one of the following:
    • If you want to create a non-production SQL Server database, named BPEDB, for stand-alone development, evaluation, or demonstration purposes:
      1. Run the script file createDatabaseMsSql2000.ddl, as described in the header of the file.
      2. Make sure that the script output contains no errors. If errors occur, you can drop the schema using the dropSchemaMsSql2000.ddl script.
    • If you want to create a production SQL Server database, create your database manually:
      1. Create the database, for example, named BPEDB.
      2. To create the schema, run the script file createSchemaMsSql2000.ddl, as described in the header of this file.
      3. Make sure that the script output contains no errors. If errors occur, you can drop the schema using the dropSchemaMsSql2000.ddl script.

Result

The SQL Server database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

Terms of use |

Last updated: Tue Feb 21 17:47:13 2006

(c) Copyright IBM Corporation 2005.
This information center is powered by Eclipse technology (http://www.eclipse.org)