...
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.
Update QAlity to the newest version before migration. Make sure it’s working correctly.
Disable or uninstall QAlity and install QAlity Plus.
Connect to your database.
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).
Code Block 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;
Use the following command to copy the data from QAlity to QAlity Plus:
Code Block 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";
Use the following commands to update sequences:
Code Block language sql 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";
...