Applying schema changes to user databases

After you check in a schema, you can upgrade the user databases to use the newer schema version. 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 a user database is an irreversible process. Before you apply 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 Administering Rational® ClearQuest®.

To apply schema changes to a user database:

  1. Start the Designer.
  2. In the ClearQuest Schema Repository Explorer view, click on the schema repository that contains the updated schema.
  3. Click View > ClearQuest Database Admin. The ClearQuest Database Admin view opens and displays a list of all user databases.
  4. Right-click on the user database that you want to upgrade and click Upgrade Database. The Upgrade User Database window opens.
  5. Select a schema version from the Versions list and click OK.

Feedback