TST_ATTACHMENT | Dynamic Data | Column Added | CONCURRENCY_DATE Added |
TST_AUTOMATION_HOST | Dynamic Data | Column Added | LAST_CONTACT_DATE added |
TST_CUSTOM_PROPERTY | Dynamic Data | Column Added | DEPENDENT_CUSTOM_PROPERTY_ID added |
TST_CUSTOM_PROPERTY_VALUE | Dynamic Data | Column Added | DEPENDENT_CUSTOM_PROPERTY_LIST_ID added |
TST_TVAULT_PROJECT | Dynamic Data | Column Added | Added column TARAVAULT_ID BIGINT |
TST_USER_ARTIFACT_FIELD | Dynamic Data | Column Added | WIDTH field added |
TST_USER_CUSTOM_PROPERTY | Dynamic Data | Column Added | WIDTH field added |
TST_TVAULT_USER | Dynamic Data | Column Added/Changed | Added column TARAVAULT_USERLOGIN and TARAVAULT_PASSWORD was changed to NVARCHAR(MAX) |
TST_INCIDENT | Dynamic Data | Column Removed | TEST_RUN_STEP_ID column removed and the data migrated to the new TST_TEST_RUN_STEP_INCIDENT table |
TST_DATA_SYNC_SYSTEM | Dynamic Data | Columns Added | CAPTION and IS_ENCRYPTED fields added, both can be left blank during upgrade |
TST_REPORT_AVAILABLE_SECTION | Dynamic Data | Columns Added | POSITION nullable field added |
TST_REPORT_CUSTOM_SECTION | Dynamic Data | Columns Added | POSITION nullable field added |
TST_USER_PROFILE | Dynamic Data | Columns Added | Added an organization field to the user profile table - which is set to allow nulls |
TST_ATTACHMENT_VERSION | Dynamic Data | Columns Changed | CURRENT_YN changed to IS_CURRENT |
TST_AUTOMATION_ENGINE | Dynamic Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE bit field |
TST_AUTOMATION_HOST | Dynamic Data | Columns Changed | ACTIVE_YN and ATTACHMENTS_YN fields changed to IS_ACTIVE and IS_ATTACHMENTS and CONCURRENCY_DATE added |
TST_DATA_SYNC_PROJECT | Dynamic Data | Columns Changed | EXTERNAL_KEY increased to 255 length |
TST_DATA_SYNC_SYSTEM | Dynamic Data | Columns Changed | Various text fields increased to 255 length |
TST_HISTORY_CHANGESET | Dynamic Data | Columns Changed | SIGNATURE_HASH added |
TST_PROJECT_ATTACHMENT_TYPE | Dynamic Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE, DEFAULT_YN changed to IS_DEFAULT |
TST_PROJECT_ROLE | Dynamic Data | Columns Changed | DOCUMENTS_ADD_YN, DOCUMENTS_EDIT_YN, DOCUMENTS_DELETE_YN removed, all other YN fields converted to IS_ bit fields |
TST_PROJECT_ROLE_PERMISSION | Dynamic Data | Data Added | Rows added for the new 'Document/Attachment' artifact type, replacing the old DOCUMENT-EDIT and DOCUMENT-EDIT flags on TST_ROLE |
TST_PROJECT_ROLE_PERMISSION | Dynamic Data | Data Added | Rows added to give Modify All users Bulk Edit permissions (by default) |
TST_RELEASE | Dynamic Data | Columns Changed | ACTIVE_YN, ITERATION_YN fields removed and replaced by Type/Status columns. ATTACHMENTS_YN and SUMMARY_YN replaced by IS_ fields. Also added nullable OWNER_ID field. Also CONCURRENCY_DATE added |
TST_RELEASE_DISCUSSION | Dynamic Data | Columns Changed | DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing) |
TST_RELEASE_TEST_CASE | Dynamic Data | Columns Changed | EXECUTION_STATUS_ID, ACTUAL_DURATION and EXECUTION_DATE added to column |
TST_REQUIREMENT_DISCUSSION | Dynamic Data | Columns Changed | DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing) |
TST_REQUIREMENT_WORKFLOW_TRANSITION | Dynamic Data | Columns Changed | IS_SIGNATURE_REQUIRED added |
TST_TASK_DISCUSSION | Dynamic Data | Columns Changed | DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing) |
TST_TASK_WORKFLOW_TRANSITION | Dynamic Data | Columns Changed | IS_SIGNATURE_REQUIRED added |
TST_TEST_CASE | Dynamic Data | Columns Changed | INDENT_LEVEL, ACTIVE_YN, FOLDER_YN, FOLDER_COUNT_XXXXX fields removed. ACTUAL_DURATION added. ATTACHMENTS_YN and TEST_STEPS_YN changed to IS_ATTACHMENTS and IS_TEST_STEPS bit fields. TEST_CASE_STATUS_ID and TEST_CASE_TYPE_ID, TEST_CASE_FOLDER_ID foreign key fields added. Also COMPONENT_IDS and IS_SUSPECT fields added |
TST_TEST_CASE_DISCUSSION | Dynamic Data | Columns Changed | DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing) |
TST_TEST_RUN | Dynamic Data | Columns Changed | ATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added |
TST_TEST_RUN | Dynamic Data | Columns Changed | Removed the IS_DELETED field (was never used) |
TST_TEST_RUN_STEP | Dynamic Data | Columns Changed | ACTUAL_DURATION, START_DATE and END_DATE added |
TST_TEST_RUNS_PENDING | Dynamic Data | Columns Changed | COUNT_NOT_APPLICABLE added |
TST_TEST_SET | Dynamic Data | Columns Changed | FOLDER_YN, INDENT_LEVEL removed. ATTACHMENTS_YN changed to IS_ATTACHMENTS. Also added TEST_SET_FOLDER_ID, EXECUTION_DATE, BUILD_EXECUTE_TIME_INTERVAL, ESTIMATED_DURATION, ACTUAL_DURATION, COUNT_XXXXXX fields |
TST_TEST_SET | Dynamic Data | Columns Changed | IS_DYNAMIC, IS_AUTO_SCHEDULED, TEST_CONFIGURATION_SET_ID, and DYNAMIC_QUERY columns added |
TST_TEST_SET_DISCUSSION | Dynamic Data | Columns Changed | DELETED renamed to IS_DELETED and IS_PERMANENT field added. Also foreign key added between TST_USER and this table (was missing) |
TST_TEST_STEP | Dynamic Data | Columns Changed | ATTACHMENTS_YN changed to IS_ATTACHMENTS bit field and CONCURRENCY_DATE added |
TST_WORKFLOW_TRANSITION | Dynamic Data | Columns Changed | IS_SIGNATURE_REQUIRED added |
TST_RELEASE_USER | Dynamic Data | Columns Renamed | VISIBLE_YN and EXPANDED_YN switched to IS_VISIBLE and IS_EXPANDED bit fields |
TST_GLOBAL_SETTING | Dynamic Data | Data Changed | Set Testing_CreateDefaultTestStep to FALSE for upgrades |
TST_REQUIREMENT_TYPE_PROJECT_WORKFLOW | Dynamic Data | Data Added | References to the new Design Element type need to be added to all existing workflows |
TST_CUSTOM_PROPERTY_DEPENDENCY | Dynamic Data | Table Added | For future use |
TST_DASHBOARD_CUSTOM | Dynamic Data | Table Added | For future use |
TST_DASHBOARD_CUSTOM_PERMISSION | Dynamic Data | Table Added | For future use |
TST_GLOBAL_SETTING_SECURE | Dynamic Data | Table Added | Migrate over the LDAP bind password and SMTP password |
TST_GRAPH_CUSTOM | Dynamic Data | Table Added | For future use |
TST_MESSAGE_ARTIFACT | Dynamic Data | Table Added | For future use |
TST_PROJECT_ARTIFACT_SHARING | Dynamic Data | Table Added | For future use |
TST_PROJECT_SETTING_VALUE | Dynamic Data | Table Added | For future use |
TST_RELEASE_TEST_CASE_FOLDER | Dynamic Data | Table Added | Calculated post-migrating used stored-proc |
TST_RELEASE_TEST_SET | Dynamic Data | Table Added | Calculated post-migrating used stored-proc |
TST_RELEASE_TEST_SET_FOLDER | Dynamic Data | Table Added | Calculated post-migrating used stored-proc |
TST_RELEASE_TYPE_PROJECT_WORKFLOW | Dynamic Data | Table Added | Create default workflow per project |
TST_RELEASE_WORKFLOW | Dynamic Data | Table Added | Create default workflow per project |
TST_RELEASE_WORKFLOW_CUSTOM_PROPERTY | Dynamic Data | Table Added | Create default workflow per project |
TST_RELEASE_WORKFLOW_FIELD | Dynamic Data | Table Added | Create default workflow per project |
TST_RELEASE_WORKFLOW_TRANSITION | Dynamic Data | Table Added | Create default workflow per project |
TST_RELEASE_WORKFLOW_TRANSITION_ROLE | Dynamic Data | Table Added | Create default workflow per project |
TST_REQUIREMENT_TEST_STEP | Dynamic Data | Table Added | For future use |
TST_SESSION | Dynamic Data | Table Added | For future use - not migrated |
TST_TEST_CASE_FOLDER | Dynamic Data | Table Added | Migrate test case folders from TST_TEST_CASE table |
TST_TEST_CASE_TYPE_PROJECT_WORKFLOW | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CASE_WORKFLOW | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CASE_WORKFLOW_CUSTOM_PROPERTY | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CASE_WORKFLOW_FIELD | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CASE_WORKFLOW_TRANSITION | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CASE_WORKFLOW_TRANSITION_ROLE | Dynamic Data | Table Added | Create default workflow per project |
TST_TEST_CONFIGURATION | Dynamic Data | Table Added | For future use |
TST_TEST_CONFIGURATION_PARAMETER_VALUE | Dynamic Data | Table Added | For future use |
TST_TEST_CONFIGURATION_SET | Dynamic Data | Table Added | For future use |
TST_TEST_CONFIGURATION_SET_PARAMETER | Dynamic Data | Table Added | For future use |
TST_TEST_RUN_STEP_INCIDENT | Dynamic Data | Table Added | Migrated from TST_INCIDENT |
TST_TEST_SET_FOLDER | Dynamic Data | Table Added | Migrate test set folders from TST_TEST_SET table |
TST_TEST_SET_PARAMETER | Dynamic Data | Table Added | |
TST_TEST_CASE_USER | Dynamic Data | Table Deleted | |
TST_TEST_SET_USER | Dynamic Data | Table Deleted | |
TST_DASHBOARD_USER_PERSONALIZATION | Dynamic Data | Data Invalid | Need to delete any existing entries (and not migrate) for the Reports dashboard since types have changed |
TST_PERMISSION | Static Data | Data Added, Columns Changed | New permission added to Bulk Edit and ACTIVE_YN changed to IS_ACTIVE |
TST_ARTIFACT_FIELD | Static Data | Columns Changed | All of the existing _YN fields were changed to IS_ bit fields |
TST_ARTIFACT_FIELD_TYPE | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE |
TST_ARTIFACT_TYPE | Static Data | Columns Changed | NOTIFY_YN, ACTIVE_YN, DATA_SYNC_YN replaced by IS_NOTIFY, IS_ACTIVE, IS_DATA_SYNC bit fields. Also new IS_ATTACHMENTS, IS_CUSTOM_PROPERTIES added |
TST_ATTACHMENT_TYPE | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE |
TST_EXECUTION_STATUS | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE bit field |
TST_GRAPH | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE |
TST_GRAPH_TYPE | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE and new custom graph type added |
TST_TEST_CASE_PRIORITY | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE bit field |
TST_TEST_RUN_TYPE | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE bit field |
TST_TEST_SET_STATUS | Static Data | Columns Changed | ACTIVE_YN changed to IS_ACTIVE bit field |
TST_ARTIFACT_FIELD | Static Data | Data Added | Rows added for the new 'Document/Attachment' artifact type |
TST_ARTIFACT_FIELD | Static Data | Data Added | Release ActiveYn, IterationYn fields disabled, new Status/Type/Owner fields added and workflow flag set to True on various Release fields |
TST_ARTIFACT_FIELD | Static Data | Data Added | Test Case ActiveYn field disabled, new Status/Type fields added and workflow flag set to True on various Test Case fields. Also ComponentIds and IsSuspect fields added to test cases |
TST_ARTIFACT_FIELD | Static Data | Data Added | Test Set BuildExecuteTimeInterval field added and position of TestSetId field incremented. Also ActiveYn changed to IsActive for automation hosts. Also added Description field for TestRuns. Also log-history set to TRUE/1 for several of the Test Run fields |
TST_GLOBAL_FILETYPES | Static Data | Data Added | JSON type added |
TST_GLOBAL_FILETYPES | Static Data | Data Added | Filetypes added for Rapise .sstest, .rest and .trp files |
TST_REQUIREMENT_TYPE | Static Data | Data Added | Design Element Added, also need to add to all workflows using |
TST_USER_COLLECTION | Static Data | Data Added | GuidedTours.State added |
TST_REPORT_SECTION_ELEMENT | Static Data | Data Added | Added test steps to the test set detailed report section |
TST_NOTIFICATION_ARTIFACT_TEMPLATE | Static Data | Data Added/Changed | Notification templates changed and new template added for 'Documents' |
TST_ARTIFACT_TYPE | Static Data | Data Changed | New entry for 'Document' artifact type added |
TST_PROJECT_COLLECTION | Static Data | Data Changed | The TestCaseSelectedRelease collection is set to ACTIVE_YN = 'N', new TestSetDetails.TestCases.Columns collection |
TST_REPORT_SECTION | Static Data | Data Changed | Report default section templates changed |
TST_DASHBOARD_CUSTOM_TYPE | Static Data | Table Added | For future use |
TST_PROJECT_SETTING | Static Data | Table Added | For future use |
TST_RELEASE_STATUS | Static Data | Table Added | |
TST_RELEASE_TYPE | Static Data | Table Added | |
TST_TEST_CASE_STATUS | Static Data | Table Added | |
TST_TEST_CASE_TYPE | Static Data | Table Added | |