Page Comparison

...

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

2. Disable or uninstall Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Turn off the DC or 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:

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

7. 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" ("COMMENT", "CREATED_DATE", "DATE", "EXECUTED_BY", "ID", "NAME" SELECT *, "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" SELECT *, "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:

   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"; SELECT SETVAL('"AO_A89232_STATUS_ID_seq"', COALESCE(MAX("ID"), 1) ) FROM public."AO_A89232_STATUS";

...

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. Disable or uninstall Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Turn off the DC or 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:

   Code Block

   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; DELETE FROM AO_A89232_STATUS; ALTER TABLE AO_A89232_STATUS AUTO_INCREMENT = 1;

7. Connect to your database.

8. 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_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"; INSERT INTO AO_A89232_ISSUE_TO_TEST_STEP SELECT * FROM AO_ABA6C4_ISSUE_TO_TEST_STEP;

...

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

2. Disable Uninstall QAlity and install QAlity Plus.

3. Make sure QAlity Plus is working correctly.

4. Turn off the DC or 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:

   Code Block
   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

   Connect to your database.

   AO_A89232_STATUS

7. Copy data
   Official Microsoft documentation: Documentation
   from:

   Code Block
   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:

   Code Block
   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

...