Moving a user database with the Designer

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

Before you begin

Complete the following tasks before moving a user database:
  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.
  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 HCL Compass 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.

About this task

When you move a user database by using the Designer, HCL Compass 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.

Procedure

  1. Start the Designer..
  2. In the HCL Compass Schema Repository Explorer view, click on the schema repository that contains the database you want to move.
  3. Click View > HCL Compass Database Admin. The HCL Compass Database Admin view opens.
  4. In the HCL Compass Database Admin view, right-click the database you want to move and click Move Database.
  5. In the Move Database window, select the new vendor for the database and select Production Database or Test Database. Click Next.
  6. Enter the required database properties. These properties are different for each database vendor.
  7. Click Finish.
    A message window opens and displays the status of the move operation.
  8. Click OK to close the message window and the Move Database window.