General Information

To upgrade from QAlity to QAlity Plus you need to complete 2 steps. The first one is changing the icon of the QAlity Test issue type and the second step is adjusting 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.

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

PostgreSQL, Oracle

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

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

2. Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Uninstall QAlity Plus.

5. Connect to your database.

6. 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).
   Tables that need their data cleared:

   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; TRUNCATE TABLE "AO_A89232_STATUS" CASCADE;

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

   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" ("COMMENT", "CREATED_DATE", "DATE", "EXECUTED_BY", "ID", "NAME", "STATUS","TEST_CASE_ID", "VERSION_ID") select "COMMENT" ,"CREATED_DATE" , "DATE" ,"EXECUTED_BY" ,"ID" ,"NAME" , "STATUS" , "TEST_CASE_ID" , "VERSION_ID" FROM "AO_ABA6C4_TEST_EXECUTION"; INSERT INTO "AO_A89232_TEST_EXECUTION_STEP" ("ATTACHMENTS", "COMMENT" , "ID" , "STATUS" , "TEST_CASE_STEP_ID" , "TEST_EXECUTION_ID") select "ATTACHMENTS" ,"COMMENT" ,"ID" , "STATUS" , "TEST_CASE_STEP_ID" , "TEST_EXECUTION_ID" 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" ("ID", "SOURCE_ISSUE_ID", "TEST_CASE_ID", "TEST_CYCLE_ID", "TEST_EXECUTION_ID", "POSITION") SELECT "ID", "SOURCE_ISSUE_ID", "TEST_CASE_ID", "TEST_CYCLE_ID", "TEST_EXECUTION_ID", 1 FROM "AO_ABA6C4_TEST_CASE_IN_CYCLE";

8. Use the following commands to update sequences:

   SELECT SETVAL('"AO_A89232_TEST_CASE_VERSION_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_CASE_VERSION"; SELECT SETVAL('"AO_A89232_TEST_CYCLE_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_CYCLE"; SELECT SETVAL('"AO_A89232_TEST_EXECUTION_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_EXECUTION"; SELECT SETVAL('"AO_A89232_TEST_EXECUTION_STEP_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_EXECUTION_STEP"; SELECT SETVAL('"AO_A89232_ISSUE_TO_TEST_STEP_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_ISSUE_TO_TEST_STEP"; SELECT SETVAL('"AO_A89232_TEST_STEP_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_STEP"; SELECT SETVAL('"AO_A89232_TEST_CASE_IN_CYCLE_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_TEST_CASE_IN_CYCLE"; SELECT SETVAL('"AO_A89232_STATUS_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_STATUS";

9. Install QAlity Plus

MySQL

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

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

2. Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Uninstall QAlity Plus(recommended option).

5. Connect to your database.

6. 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).
   Tables that need their data cleared:

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

8. Install QAlity Plus

SQL Server, Azure SQL

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

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

2. Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Uninstall QAlity Plus(recommended option).

5. Connect to your database.

6. 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 records in these tables (they will not come back after the migration).
   Official Microsoft documentation: Documentation
   Tables that need their data cleared:

7. Copy data
   Official Microsoft documentation: Documentation
   from:

   to:

8. Install QAlity Plus

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:

   Open

   

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

5. Click Save.

It doesn’t work?

If you have problems with migrating the data feel free to contact our support.