...
- We are copying data from AO_32F7CE_AO* tables into AO_32F7CE_DB* tables.
- The reason is, AO tables were limited to 2 billion IDs, whereas the new tables are virtually unlimited. This is important so our loyal legacy customers don't run into this problem, and we can safely advertise being ready for large databases.
- When some data is migrated, we put a timestamp in "MIGRATIONDATE", and we never look at it again. Destroy it if you want! You can look into the "MIGRATIONMESSAGE" to see whether there was an issue.
- If a migration wasn't successful for a record, you can restart the migration, for all or for this record. We have designed so that the migration is only updates the target data, instead of deleting-and-recreating it, so, if you have already modified the target data, this is not a problem.
The tables:
| Old table | New table | Observations |
|---|---|---|
AO_32F7CE_AOREQUIREMENT | AO_32F7CE_DBREQUIREMENT | Requirements. Columns have been cleaned up |
| AO_32F7CE_AOREQUIREMENT_LINK | AO_32F7CE_DBLINK | Links to requirements. Types are cleaned up. |
| AO_32F7CE_AODEPENDENCY | AO_32F7CE_DBDEPENDENCY | Dependencies. Much better cross-baseline management |
| AO_32F7CE_AOPROPERTY | AO_32F7CE_DBPROPERTY AO_32F7CE_DBPROPERTYNAME | Properties. Added the implementation of the External Properties |
AO_32F7CE_AOINTEGRATION | AO_32F7CE_DBAPPLINK | The queue and the descriptor. |
| AO_32F7CE_AOBASELINE | AO_32F7CE_DBBASELINE | The baseline descriptors. |
| AO_32F7CE_AOISSUE_TEMPLATE | AO_32F7CE_DBISSUE_TEMPLATE | Templates for the Jira Bulk Issue Creation. |
| AO_32F7CE_AOTRACEABILITYMATRIX | AO_32F7CE_DBTRACEABILITYMATRIX | Traceability matrixes. |
| AO_32F7CE_AOSETTINGS | AO_32F7CE_DBSETTINGS | Settings. |
| In Jira | ||
AO_42D05A_REMOTEREQUIREMENT
| AO_42D05A_DBREMOTEREQUIREMENT | The requirements and their associations with Jira issues. |
| AO_42D05A_RYAUDITTRAIL | AO_42D05A_DBAUDITTRAIL | The history of requirements (large table). |
| AO_42D05A_INTEGRATION AO_42D05A_AOQUEUE_MESSAGE | AO_42D05A_DBINTEGRATION | The queue and the descriptor. |
| AO_42D05A_ISSUE_OPERATION_JOB | AO_42D05A_DBOPERATIONJOB | The Jira Bulk Issue Creation jobs, while they are executing. |
| AO_42D05A_TASK | We keep the old table. | Status of the background migration tasks. |
Known issues
There are error messages, what should I do?
...