Tools for managing databases

Administrators use a variety of tools to create and manage schema repositories, connections, user databases and other related entities. Modification of Rational® ClearQuest® data and tables is supported only when using ClearQuest tools.

The tools administrators use and tasks they perform include:

Database vendor tools

Use tools provided by the database vendors to perform these tasks:
  • Installing the database management system
  • Creating empty database containers before creating schema repositories and user databases
  • Setting the character set (code page)
  • Backing up schema repositories and user databases

Maintenance Tool

Use the Maintenance Tool to perform these tasks:
  • Creating and managing schema repositories, which includes updating the physical location of a schema repository if it was moved without using the Maintenance Tool
  • Creating and modifying connections and connection profiles
  • Creating sample user databases
  • Moving schema repositories to different locations and vendor databases
  • Upgrading schema repositories to new feature levels of Rational ClearQuest
  • Setting the Rational ClearQuest data code page for schema repositories

Designer

Use the Designer to perform these tasks:
  • Customizing schemas
  • Creating new user databases and associating them with schemas
  • Creating test user databases
  • Moving user databases to different locations and vendor databases
  • Deleting and restoring user databases
  • Upgrading existing user databases to new schema revisions
Parent topic: Managing databases