Applying schema changes to user databases

After you check in a schema, you can upgrade the user databases that used an earlier version of it. You do not have to upgrade these databases immediately, but the changes to the schema are not available until you do.

Before you begin

Upgrading the user database is an irreversible process. Before applying schema changes, back up the user database. Also, immediately before you apply schema changes, verify that no users are logged in to the database. The upgrade operation fails if users are connected to the user database. Users cannot log in during the upgrade process, but they cannot be disconnected.

About this task

When a user database is associated with a specific schema version, you can apply only newer versions of the same schema to that database. You cannot apply earlier versions or a different schema.

For more information about databases, see the online help for the Rational® ClearQuest® Administrator.

To apply schema changes to a user database:

Procedure

Start the Designer.
Click Database > Upgrade Database.
The Designer prompts you to back up the schema repository and the user database. If you have not done so, click No; otherwise, click Yes.
Select a database from the Database list and click Next.
Select a schema version from the Versions list and click Finish.