Migrating from HP ALM to QMetry using QMetry Migration Tool

• Migrates Requirements, Tests and all their versions, rich text in Test Steps.

• Migrates Test Data in Test Steps, Test Sets, Test Runs or Executions, Defects.

• Migrates custom fields and their values for all the assets.

• Migrates folder structure.

• Migrates comments for all the assets.

• Migrates linkages between assets.

• Migrates all the attachments & URL links.

• Support for Mapping of HP-ALM Enumerated fields and their values with QMetry fields.

• Install JDK 1.8.0.

• Install MySQL 5.7 or above.

• Operating Systems: Windows 10, Linux - Cent OS 7, RHEL

• CPU: 8 Cores, RAM: 16 GB Reference:

• Install Apache Tomcat server.

• https://archive.apache.org/dist/tomcat/tomcat-8/v8.5.60/bin/ (select as per the system you are using).

• ALM version 12.55 (Utility is tested on)

• Get your QMetry Migration Tool (qmalm.war) and its license (qmetry-license-version-1.0) from Professional Services team.

• QMetry and ALM should be running on your system with valid license.

• Set UTC Time Zone in QMetry as all the dates from ALM will be migrated in to QMetry as per UTC time zone.

• Create ALM users in QMetry.

• Turn off API limits and Audit Logging.

  • Follow these steps in QMetry database. Enter 'root' database credentials when prompted.

    sudo su -
    docker exec -it qmetry_rds_1 bash
    musql -uroot -p -A
    USE qmetry;

  • Run the following SELECT query to check the status and the UPDATE query to disable audit logs and email notifications.

    <listitem>

    0=disabled 1=Enabled

    • SELECT CAST(isEmailEnabled AS UNSIGNED) as isEmailEnabled , CAST(isLogEnabled AS UNSIGNED) as isLogEnabled from client;

    • UPDATE `client` SET` isEmailEnabled` = b'0', `isLogEnabled` = b'0';

    </listitem>

  • To re-enable them run the following UPDATE query, and to check its updated value run the SELECT query.

    • UPDATE `client` SET `isEmailEnabled` = b'1', `isLogEnabled` = b'1';

    • SELECT CAST(isEmailEnabled AS UNSIGNED) as isEmailEnabled , CAST(isLogEnabled AS UNSIGNED) as isLogEnabled from client;

  • Type \q to exit MySQL DB.

  • Type exit to exit the docker container.

• Install Certificate in JDK on the machine running the migration utility.

  • Follow the steps specified here : How to install certificate in JDK?

• Run the migration utility:

  • Open command prompt and go to qmalm.war directory.

  • Put license file "qmetry-license-version-1.0" beside qmalm.war file.

  • Run the following commands:

    cd PATH_TO_WAR_FILE
    java -jar qmalm.war --spring.datasource.username=dbusername --spring.datasource.password=dbpwd

  • The application should be accessible from the same machine using URL:  http://localhost:8080/qmalm.

  After logging into the ALM page of the Utility, proceed with following steps:

• Remove or rename duplicate list values for system and custom fields in ALM as QMetry does not support creation of duplicate values.

• Create a ALM Template Project in QMetry.

The application should be accessible from the same machine using the URL : http://localhost:8080/qmalm.

• Open the command prompt and go to the qmalm.war directory.

• Put license file besides qmalm.war file.

• Run the following command by giving the path of the qmalm.war file : PATH_TO_WAR_FILE > java -jar qmalm.war --spring.datasource.username= <DB USERNAME> --spring.datasource.password= <DB PASSWORD>

  cd <PATH_TO_WAR_FILE>
  java -jar qmalm.war --spring.datasource.username=<dbusername> --spring.datasource.password=<dbpwd>
  

• Capture Migration Logs

  • The logs should be present in the logs folder of the migration utility directory containing the .war file. Zip the logs folder and send it to Professional Services team for investigation.

• Resume the Migration

  • The migration can be resumed by refreshing the existing page or clicking "Resume" on the migration page.

• Reverting API metering, Audit history logging and Email Notifications.

  • Run the following UPDATE query, and to check its updated value run the SELECT query.

    • UPDATE `client` SET `isEmailEnabled` = b'1', `isLogEnabled` = b'1';

    • SELECT CAST(isEmailEnabled AS UNSIGNED) as isEmailEnabled , CAST(isLogEnabled AS UNSIGNED) as isLogEnabled from client;