Upgrade Server


General Information

To upgrade from QAlity to Qality Plus you need to complete 2 steps. The first one is about changing the icon of the QAlity Test issue type and the second step is about copying data in the database.

 

Data Migration

On Jira Server and Data Center the plugin data is stored on the client instance. This means that a quick manual migration will be required if you would like to use QAlity data on QAlity Plus. It needs to be done by the administrator since we will work directly on the database.

Backup your database before

For detailed instruction please select which database you have on your instance and follow the steps.


PostgreSQL, Oracle

  1. It’s recommended to use QAlity and QAlity Plus separately and never at the same time.

  2. Update QAlity to the newest version before migration. Make sure it’s working correctly.

  3. Disable or uninstall QAlity and install QAlity Plus

  4. Connect to your database.

  5. If you installed QAlity Plus before migration and added some data then it’s required to delete the records in them so we have empty tables (they will not come back after the migration).

    1 2 3 4 5 6 7 TRUNCATE TABLE "AO_A89232_TEST_CASE_IN_CYCLE" CASCADE; TRUNCATE TABLE "AO_A89232_TEST_CASE_VERSION" CASCADE; TRUNCATE TABLE "AO_A89232_TEST_CYCLE" CASCADE; TRUNCATE TABLE "AO_A89232_TEST_EXECUTION" CASCADE; TRUNCATE TABLE "AO_A89232_TEST_EXECUTION_STEP" CASCADE; TRUNCATE TABLE "AO_A89232_ISSUE_TO_TEST_STEP" CASCADE; TRUNCATE TABLE "AO_A89232_TEST_STEP" CASCADE;
  6. Use the following command to copy the data from QAlity to QAlity Plus:

    1 2 3 4 5 6 7 INSERT INTO "AO_A89232_TEST_CASE_VERSION" SELECT * FROM "AO_ABA6C4_TEST_CASE_VERSION"; INSERT INTO "AO_A89232_TEST_CYCLE" SELECT * FROM "AO_ABA6C4_TEST_CYCLE"; INSERT INTO "AO_A89232_TEST_EXECUTION" SELECT * FROM "AO_ABA6C4_TEST_EXECUTION"; INSERT INTO "AO_A89232_TEST_EXECUTION_STEP" SELECT * FROM "AO_ABA6C4_TEST_EXECUTION_STEP"; INSERT INTO "AO_A89232_ISSUE_TO_TEST_STEP" SELECT * FROM "AO_ABA6C4_ISSUE_TO_TEST_STEP"; INSERT INTO "AO_A89232_TEST_STEP" SELECT * FROM "AO_ABA6C4_TEST_STEP"; INSERT INTO "AO_A89232_TEST_CASE_IN_CYCLE" SELECT * FROM "AO_ABA6C4_TEST_CASE_IN_CYCLE";
  7. We are done!


MySQL

  1. It’s recommended to use QAlity and QAlity Plus separately and never at the same time.

  2. Update QAlity to the newest version before migration. Make sure it’s working correctly.

  3. Disable or uninstall QAlity and install QAlity Plus

  4. If you installed QAlity Plus before migration and added some data then it’s required to delete the records in them so we have empty tables (they will not come back after the migration).

    1 2 3 4 5 6 7 8 9 10 11 12 13 14 DELETE FROM AO_A89232_TEST_STEP; ALTER TABLE AO_A89232_TEST_STEP AUTO_INCREMENT = 1; DELETE FROM AO_A89232_TEST_CASE_IN_CYCLE; ALTER TABLE AO_A89232_TEST_CASE_IN_CYCLE AUTO_INCREMENT = 1; DELETE FROM AO_A89232_ISSUE_TO_TEST_STEP; ALTER TABLE AO_A89232_ISSUE_TO_TEST_STEP AUTO_INCREMENT = 1; DELETE FROM AO_A89232_TEST_EXECUTION_STEP; ALTER TABLE AO_A89232_TEST_EXECUTION_STEP AUTO_INCREMENT = 1; DELETE FROM AO_A89232_TEST_EXECUTION; ALTER TABLE AO_A89232_TEST_EXECUTION AUTO_INCREMENT = 1; DELETE FROM AO_A89232_TEST_CYCLE; ALTER TABLE AO_A89232_TEST_CYCLE AUTO_INCREMENT = 1; DELETE FROM AO_A89232_TEST_CASE_VERSION; ALTER TABLE AO_A89232_TEST_CASE_VERSION AUTO_INCREMENT = 1;
  5. Connect to your database.

  6. Use the following command to copy the data from QAlity to QAlity Plus:

    1 2 3 4 5 6 7 INSERT INTO AO_A89232_TEST_CASE_VERSION SELECT * FROM AO_ABA6C4_TEST_CASE_VERSION; INSERT INTO AO_A89232_TEST_CYCLE SELECT * FROM AO_ABA6C4_TEST_CYCLE; INSERT INTO AO_A89232_TEST_EXECUTION SELECT * FROM AO_ABA6C4_TEST_EXECUTION; INSERT INTO AO_A89232_TEST_EXECUTION_STEP SELECT * FROM AO_ABA6C4_TEST_EXECUTION_STEP; INSERT INTO AO_A89232_TEST_STEP SELECT * FROM AO_ABA6C4_TEST_STEP; INSERT INTO AO_A89232_TEST_CASE_IN_CYCLE SELECT * FROM AO_ABA6C4_TEST_CASE_IN_CYCLE; INSERT INTO AO_A89232_ISSUE_TO_TEST_STEP SELECT * FROM AO_ABA6C4_ISSUE_TO_TEST_STEP;
  7. We are done!

SQL Server, Azure SQL

  1. It’s recommended to use QAlity and QAlity Plus separately and never at the same time.

  2. Update QAlity to the newest version before migration. Make sure it’s working correctly.

  3. Disable QAlity and install QAlity Plus

  4. If you installed QAlity Plus before and added some data then it’s required to delete the records in them so we have empty tables before migration. Delete all record in these tables (they will not come back after the migration)
    Official Microsoft documentation: Documentation

    1 2 3 4 5 6 7 AO_A89232_TEST_CASE_IN_CYCLE AO_A89232_TEST_CASE_VERSION AO_A89232_TEST_CYCLE AO_A89232_TEST_EXECUTION AO_A89232_TEST_EXECUTION_STEP AO_A89232_ISSUE_TO_TEST_STEP AO_A89232_TEST_STEP
  5. Connect to your database.

  6. Copy data
    Official Microsoft documentation: Documentation
    from:

    1 2 3 4 5 6 7 AO_ABA6C4_TEST_CASE_IN_CYCLE AO_ABA6C4_TEST_CASE_VERSION AO_ABA6C4_TEST_CYCLE AO_ABA6C4_TEST_EXECUTION AO_ABA6C4_TEST_EXECUTION_STEP AO_ABA6C4_ISSUE_TO_TEST_STEP AO_ABA6C4_TEST_STEP

    to:

    1 2 3 4 5 6 7 AO_A89232_TEST_CASE_IN_CYCLE AO_A89232_TEST_CASE_VERSION AO_A89232_TEST_CYCLE AO_A89232_TEST_EXECUTION AO_A89232_TEST_EXECUTION_STEP AO_A89232_ISSUE_TO_TEST_STEP AO_A89232_TEST_STEP
  7. We are done!


Icon change

Since the icon used by QAlity Test was from the QAlity addon that was disabled/uninstalled you will encounter a missing icon. To fix this follow the steps:

  1. Click the cog menu in the upper right corner and select issues.

  2. Search for QAlity Test and click edit on the right side.

  3. Download this icon:

  4. On the new screen click the select image, then click choose image and select previously downloaded image

  5. Click Save.

  6. We are done!


It doesn’t work

If you have problems with migrating the data feel free to contact our Support:

https://soldevelo.atlassian.net/servicedesk/customer/portal/6