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
configuration scripts for Business Process Choreographer are located:
- If your database is not on the same server as your application
server:
- 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
- Change to the directory where you copied the DDL 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 the script file createDatabaseMsSql2000.ddl,
as described in the header of the file.
- 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:
- Create the database, for example, named BPEDB.
- To create the schema, run the script file createSchemaMsSql2000.ddl,
as described in the header of this file.
- 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.