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