Creating a user database

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:

  1. Click Start the Designer. If the Open Schema window opens, click Cancel.
  2. Click Database > New Database.
  3. 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.
  4. Optional: Enter a comment and click Next.
  5. 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.
  6. 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.
  7. 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.
  8. In Step 4 of the New Database Wizard, select a schema from a list of predefined schemas, to associate with the new user database.
  9. Click Finish.

Feedback