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 Business Process Choreographer configuration scripts for your database system are located:
    • On Windows® systems, enter:
      cd install_root\dbscripts\ProcessChoreographer\SQLServer
    • On UNIX® and Linux® systems, enter:
      cd install_root/dbscripts/ProcessChoreographer/SQLServer
  4. If your database is not on the same server as your application server:
    1. Copy the SQL scripts for your database from the ProcessChoreographer directory on your application server to a suitable directory on the server that hosts your database:
      clearSchema.sql
      createDatabase.sql
      createDatabaseUnicode.sql
      createSchema.sql
      createSchemaUnicode.sql
      dropSchema.sql
    2. Change to the directory where you copied the SQL 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 one of the following scripts as described in the header of the file.
        • createDatabase.sql
        • createDatabaseUnicode.sql for a Unicode database
      2. Make sure that the script output contains no errors. If errors occur, you can drop the schema using the dropSchema.sql 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 appropriate script file as described in the header of this file.
        • createSchema.sql
        • createSchemaUnicode.sql if you created a Unicode database
      3. Make sure that the script output contains no errors. If errors occur, you can drop the schema using the dropSchema.sql script.

Result

The database for Business Process Choreographer exists.

What to do next

Continue configuring in the parent topic at step 2.

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