Functionality was added to Quality Center Site Administration in QCv9.2 patch 11. It enables the migration of a Quality Center project repository stored in the database to be stored on the file system.

The feature is enabled only for projects whose repository is currently stored in the database. When employed on a domain, only projects whose repositories are in the database are affected.

The process copies the repository from the database to the file system, leaving the original repository intact in the database.

Before You Start:

1. Back up the project.
2. Make sure you have enough disk space
   in the project directory to store
   the entire project repository. The
   disk space needed is approximately
   the same amount required by the
   project's scheme. The new feature's
   user interface will report the exact
   required disk space later in the
   process.
3. Make sure the project directory is
   empty.
4. Deactivate the project.
5. While running the tool, the log
   level should be set to 'Flow'.
6. On a UNIX machine, make sure to set
   locale and restart the server, or
   files will not be copied.
7. Disable antivirus scanning, enlarge
   JBoss heap size to 1.5 GB, and try
   to avoid Windows 2000 if possible,
   especially when working on large
   projects.

To Migrate a Database Repository for a Project:

1. In Site Administration, click the
   Site Projects tab, and select the
   project whose repository you want to
   migrate.

2. Click on the newly added Copy
   Database Repository To File System
   button. The system calculates the
   database size. This might take a few
   minutes.

3. A dialog box opens and displays how
   much disk space is needed for this
   operation. Click OK to continue.

4. After the process completes, the
   data in the REPOSITORY table in the
   project's scheme is no longer used
   or needed, and can be deleted to
   save database disk space. You can
   use the following SQL in order to
   delete the repository table
   content:

TRUNCATE TABLE Project_scheme.REPOSITORY

To Migrate Database Repositories for all Projects in a Domain:

1. In Site Administration, click the
   Site Projects tab and select the
   domain whose projects' repositories
   you want to migrate.

2. Click on the newly added Copy
   Database Repository To File System
   button. The system then calculates
   the database size. This might take
   a few minutes.

3. A dialog box opens displaying a
   list of projects in the selected
   domain whose repository is in the
   database. Repository sizes and the
   total size are also listed.

4. In this dialog box, you can select
   the projects whose database
   repositories you want to migrate.

5. Click OK. Quality Center iterates
   through the selected projects and
   applies the repository migration
   process sequentially, and informs
   you when the process is complete.

6. After the process completes, the
   data in the REPOSITORY tables in
   the projects' schemes is no longer
   used or needed, and can be deleted
   to save database disk space. You
   can use the following SQL for this
   on each of the projects' schemes in
   order to delete the repository
   table content:

TRUNCATE TABLE Project_scheme.REPOSITORY

Note: If the process aborts in the middle of migrating a project repository, you must delete the content of the directory of the partially migrated project before reactivating the process, except for dbid.xml.