Highlighted
Absent Member.
Absent Member.
5523 views

Quality Center - Database or File Repository

Jump to solution

We are upgrading from Quality Center 9.2 to Quality Center 10.  How do we know if the repository is stored in the file system or database for each of the 40 projects we have set up.

 

Thanks

0 Likes
1 Solution

Accepted Solutions
Highlighted
Outstanding Contributor.
Outstanding Contributor.

From QC10,  repository in Database is removed, if you want to migrate the project from 9.x ( repository in DB) to QC 10. they should first need to mmove it to file repository, alter can upgrade to QC10.

Note: this feature is removed from QC10, and it will not be available in later versions of QC.

If you have large number of projects, to check which are on DB and which are on File repository.
Refer PR_REPOSITORY_IN_DB column in PROJECTS table ( in Qcsiteadmin_Db ).

Cheers
-------------
When your problem has been solved, accept the solution by clicking the "Accept as Solution" button to help other members in the future!

Clicking the "Kudos star" is a great way to say thanks! 🙂
--------------

View solution in original post

0 Likes
9 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hello there!

 

There is a parameter in the site configuration which points to your base repository.

You should be able to find out here your projects and reposirotries, if they are stored in file system.

 

Also, if you click on the the project name, and drill down to the cross_ref table. If this table is empty, it's usually indicative of the fact that your repository is in file system. (If it was in the database, this table would have data in it pointing teh attachements etc to where in the DB they are located.).

 

I'd appreciate someone else commenting on this though, just to ensure i'm not giving incorrect advice.

 

Regards

 

Haroon Malik

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

QC10 no longer offers the option.  Everything is stored in the file repository.

0 Likes
Highlighted
Absent Member.
Absent Member.

Hi,

select each project in the Site Projects tab (Siteadmin area) and look on right side. You will see there a path to the repository or you will see there that the project repository is on the database

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hi Jeff,

 

interesting to here about lack of database repository.

Don't suppose you know if QC11 will have this feature re-introduced at all??

 

(have a copy downloaded, just need to get a server to install it on....)

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

QC 10 allows a database repository  - th efile system option was removed.  See the manual, we just migrated to QC 10 with the help of HP Professional Services

0 Likes
Highlighted
Outstanding Contributor.
Outstanding Contributor.

From QC10,  repository in Database is removed, if you want to migrate the project from 9.x ( repository in DB) to QC 10. they should first need to mmove it to file repository, alter can upgrade to QC10.

Note: this feature is removed from QC10, and it will not be available in later versions of QC.

If you have large number of projects, to check which are on DB and which are on File repository.
Refer PR_REPOSITORY_IN_DB column in PROJECTS table ( in Qcsiteadmin_Db ).

Cheers
-------------
When your problem has been solved, accept the solution by clicking the "Accept as Solution" button to help other members in the future!

Clicking the "Kudos star" is a great way to say thanks! 🙂
--------------

View solution in original post

0 Likes
Highlighted
Regular Contributor.. Regular Contributor..
Regular Contributor..

In QC 10 the repository must be on the file system. therefore, before you can upgrade, you must migrate your Object Repository to the file system. Be aware, that once you have a project with the repository in the database, the tables are changed, so when you run the upgrade tool provided bij HP, it will give you loads of errors about the tables. You will need to remove several columns etc from the database, before the upgrade will be complete! So have a DBA standby when you upgrade your projects.

0 Likes
Highlighted
Absent Member.
Absent Member.

You can also find out in the QC 9.2 system where the project repository is stored (FS or DB) from the Site Projects tab in Site Admin, under Project Details on right side of screen as I recall.

 

As mentioned above by a poster, is is not possible to store the QC Repository in the DB, however, QC 11 does introduce Optimized Repository feature that will reduce duplicate entries in the FS.

 

 

0 Likes
Highlighted
Absent Member.
Absent Member.

projects in QC 9.2 should be copied back to the FS before upgrade to 10 or 11, it's not possible to upgrade while the projects repository is stroed in the DB.

 

Critical to review the Upgrade Assessment Guide, plan and test with staging before migrating a project in production.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.