Moving a schema repository using the Maintenance Tool

A schema repository can be moved to a new location or to a different database management system using the Maintenance Tool.

When you move a schema repository using the Maintenance Tool, Rational® ClearQuest® copies the schema repository to the new location, locks the old schema repository, and marks the copy in the new location as the active schema repository.

Super User privileges are required to perform this task.

Before moving a schema repository, complete these preliminary tasks:

  1. Create an empty database in the new location using your vendor tool. You can create Microsoft Access databases with the Maintenance Tool. To create other supported databases, you must use the database vendor tools. For more information about configuring vendor databases, see the IBM Rational ClearQuest and ClearQuest MultiSite Installation and Upgrade Guide.
  2. Instruct all users to log off from the databases. New users cannot access the databases while you are moving the schema repository, but users who are currently logged in when the process begins cannot be detected or logged off. Some supported databases provide a tool for logging users off the database. Determine whether your database vendor has such a tool.
  3. Back up all Rational ClearQuest databases, even if you are moving only one schema repository or one user database. Backups prevent data loss due to unforeseen circumstances, such as network failure, that might occur during the move.

To move a schema repository using the Maintenance Tool:

  1. Start the Maintenance Tool.
  2. In the Existing Connections window, select the schema repository that you want to move and click Schema Repository > Move.
  3. Enter your logon name and password, and click Next. Databases are locked while they are being moved.
  4. Enter the schema repository properties that you want to move. Select a database vendor and enter the required vendor database properties. The required properties are different for each database vendor. For more information, see Vendor database properties.
  5. Click Finish.
The final step in the process is distributing new connection information to all team members.

To distribute new connection information, see Connection profiles.


Feedback