Migrate a Quality Center project repository from the database to the file system

  • Questions
  • Migrate a Quality Center project repository from the database to the file system
Question ID: 104043
0
0

How can I migrate a Quality Center project from 'repository in database' to the 'file system repository'?

Marked as spam
Posted by (Questions: 15, Answers: 10)
Asked on February 8, 2010 8:54 pm
12 views
Answers (1)
1
Private answer

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.

Marked as spam
Posted by (Questions: 6, Answers: 167)
Answered on February 8, 2010 9:50 pm