Use this task to create a Microsoft® SQL Server database for
Business Process Choreographer.
Steps for this task
- 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.
- Make sure that the database server and that the Distributed Transaction
Coordinator (DTC) are running.
- 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:
- If your database is not on the same server as your application
server:
- 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
- Change to the directory where you copied the SQL scripts.
- 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:
- Run one of the following scripts as described in the header of the file.
- createDatabase.sql
- createDatabaseUnicode.sql for a Unicode database
- 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:
- Create the database, for example, named BPEDB.
- 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
- 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.