Sunday 11 February 2018

QC to ALM upgrade high-level steps involved

Upgrading QC to ALM is not easy until unless if we choose right process which suites to our current project landscape.

Following are the generic steps which will helps us in upgrading QC to ALM in Linux server

1. Prepare ALM upgrade requirement document
2. Request for ALM compatible Linux server
3. Set up directories and mount points in Linux
4. Prepare ALM upgrade technical approach document
5. Install DB(Oracle) server in Linux
6. Install ALM server in Linux
7. Stop ALM and QC production server
8. Back up the project repositories and DB schemas from source (QC old system)
9. Shut down Oracle DB server in ALM installed in Linux server
10. Export and import DB schemas in Oracle DB
11. Up QC production server and continue using till ALM live upgrade completed
12. Place the project repositories in the appropriate directories
13. Consider sample project for upgrade and prepare dbid.xml file, schema exception files..etc
14. Up ALM and DB server
15. Login to site administrator and perform sample project upgrade
16. Carry out testing on the upgraded project
17. Prepare cutover plan
18. Get approval from management for the QC upgrade to Go-Live
19. Notify to all QC old system users about the downtime and new ALM server
20. Shut down QC old system - production project
21. Backup the project repository from QC old system
22. Backup the DB schema files(Project and Site Admin) from QC old system
23. Cross check the files and directory count and total size of the backed up repository and schema
24. mount project repository to new linux server
25. Perform schema export/import to new DB server
26. Check DB User permission
27. Run SQL queries in following order
a. qc_sys_db___oracle.sql
b. qc_admin_db___oracle.sql
c. qc_project_db___oracle.sql
28. Update dbid.xml file with latest parameters
29. Update schemaexception file
30. Set "SRM_SKIP_DB_LOCALE_INCONSISTENCY" value as Yes in the parameters section from SiteAdmin
31. Verify and repair project from site admin
32. Upgrade the project from SiteAdmin
33. Up ALM server
34. Perform smoke testing on ALM
35. Notify all QC old system users about the upgrade successful
36. Run Asset Upgrade tool on upgraded project to upgrade UFT scripts

No comments:

Post a Comment