When you create a user database using the Designer, you apply a
schema version to the user database. The copy of the applied schema version
resides in the user database. The schema version defines the process model
and forms for the defect and change tracking system.
Before you create a user database, you must create an empty database
container with tools provided by the database vendor.
To create a user database:
- Click Start the Designer. If the Open Schema
window opens, click Cancel.
- Click .
- In Step 1 of the new Database Wizard, enter a logical database
name for the user database. The name must be five or fewer alphanumeric characters.
- Optional: Enter a comment and click Next.
- In Step 2 of the New Database Wizard, select the vendor of the
database to use for the user database and enter the required database properties.
These properties for each database are different.
- If you select Microsoft SQL Server, Oracle RDBMS, or IBM DB2 as the vendor
database, enter the physical database name of one of the empty databases that
you created with the database vendor tools.
- When you create a DB2 user database, the User Name property must be a
user identity with Database Administrator authority for the DB2 database.
- If you select Microsoft Access, enter a physical database name. The Designer
creates a new database with that name.
- At the end of Step 2, you can specify whether the user database
is a production database or a test database. The default setting is Production
Database. Then click Next.
- In Step 3 of the New Database Wizard, enter a value (in minutes)
in the Timeout and Poll Interval fields.
If you do not want the database to time out for idle connections, set both
to zero (0). Click Next.
- In Step 4 of the New Database Wizard, select a schema from a list
of predefined schemas, to associate with the new user database.
- Click Finish.