Creating a test database

A test database is a temporary database that you create when developing a new schema or a new version of an existing schema. You then create a test configuration that uses the test database to verify that the new schema performs as expected, without risking damage to production data. Note that you can set up your test configuration to test your schema against multiple test databases.

About this task

The procedure for creating a test database is the similar to the procedure for creating a user database.

Procedure

To create a test database:
  1. Start the Designer.
  2. In the Schema Repository Explorer view, click on the schema repository where you want to add the test database.
  3. Click View > HCL Compass Database Admin.
    The Database Admin view opens.
  4. In the Database Admin view, click the Create Database button.
  5. The New Database wizard prompts you through the process of creating a database. Provide a name for the database that is between one and five characters long that you can recognize as a test database.
  6. Select Test Database for the Database Type.
  7. Click Next and complete the wizard to specify vendor-specific properties for the new test database.

Results

  • For information about configuring database properties, see the HCL Compass Administrator role Help.
  • For more information, see Upgrading packages and the information about setting the HCL Compass data code page value in the online help for the Administrator's role.

You are ready to check out the schema and modify it. When you are ready to test your changes to the schema, you will create a test configuration that uses this test database and then run the test configuration. For more information, see To set the test database for a schema.