Moving a user database with the Designer

A user database can be moved to a new location or to a different database management system using the Designer.

When you move a user database using the Designer, Rational® ClearQuest® copies the user database to the new location, locks the user database, and marks the copy in the new location as the active user database.

Super User privileges are required to perform this task.

Before moving a user database, 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 Designer. 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 user database, 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 user database. Backups prevent data loss due to unforeseen circumstances, such as network failure, that might occur during the move.

To move a user database using the Designer:

  1. Start the Designer. If the Open Schema pane opens, click Cancel.
  2. Click Database > Move User Database.
  3. In the Move User Database window, select a logical database name and click Properties.
  4. In the Database Properties window, select the new vendor for the database and fill in the database properties, including whether the database is a production database or a test database.
  5. Click Move. The Moving Database window displays the status of the move operation. To save the status message in a file, click Save Status As and specify a file name. Click Save.
  6. Click OK to close the Moving Database window; then click OK in the database update message.
  7. Click OK to close the Move User Database window.

Feedback