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 use the test database to verify that the new schema performs as expected, without risking damage to production data.

If clients that are running versions of DevOps Plan software earlier than version 2003.06.00 are going to access your test database, you must apply the CharacterSetValidation package and set the DevOps Plan data code page value for the test database.

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

To create a test database:

Start the Designer. When the Open Schema window opens, click Cancel.
Click Database > New Database.
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.
In Step 2 of 4, select Test Database near the bottom of the screen.
In Step 4 of 4, select the schema and schema version that you are modifying and associate this with the test database that you are creating.

For information about configuring database properties, see the DevOps Plan Administrator role Help.
For more information, see Upgrading packages and the information about setting the DevOps Plan 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 set this test database and use it for your testing. For more information, see To set the test database for a schema.