Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • We are copying data from AO_32F7CE_AO* tables into AO_32F7CE_DB* tables.
  • 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.

In Jira, it is similar, the background task executes every 3 minutes and there are fewer records, so we expect the migration to be even faster. During the migration, the queue is disabled.

The tables:

Old tableNew tableObservations

AO_32F7CE_AOREQUIREMENT

AO_32F7CE_DBREQUIREMENT

Requirements. Columns have been cleaned up

AO_32F7CE_AOREQUIREMENT_LINKAO_32F7CE_DBLINKLinks to requirements. Types are cleaned up.
AO_32F7CE_AODEPENDENCYAO_32F7CE_DBDEPENDENCYDependencies. Much better cross-baseline management
AO_32F7CE_AOPROPERTYAO_32F7CE_DBPROPERTY
AO_32F7CE_DBPROPERTYNAME
Properties. Added the implementation of the External Properties

AO_32F7CE_AOINTEGRATION
AO_32F7CE_AOINTEGRATION_QUEUE

AO_32F7CE_DBAPPLINK
AO_32F7CE_DBAPPLINKQUEUE

The queue and the descriptor.
AO_32F7CE_AOBASELINEAO_32F7CE_DBBASELINEThe baseline descriptors.
AO_32F7CE_AOISSUE_TEMPLATEAO_32F7CE_DBISSUE_TEMPLATETemplates for the Jira Bulk Issue Creation.
AO_32F7CE_AOTRACEABILITYMATRIXAO_32F7CE_DBTRACEABILITYMATRIXTraceability matrixes.
AO_32F7CE_AOSETTINGSAO_32F7CE_DBSETTINGSSettings.
In Jira

AO_42D05A_REMOTEREQUIREMENT
AO_42D05A_ISSUELINK



AOIssueOperationjob

AORemoteRequirement
AOTask

AO_42D05A_DBREMOTEREQUIREMENT
AO_42D05A_DBISSUELINK

The requirements and their associations with Jira issues.
AO_42D05A_RYAUDITTRAILAO_42D05A_DBAUDITTRAILThe history of requirements (large table).
AO_42D05A_INTEGRATION
AO_42D05A_AOQUEUE_MESSAGE

AO_42D05A_DBINTEGRATION
AO_42D05A_AOQUEUEMESSAGE

The queue and the descriptor.
AO_42D05A_ISSUE_OPERATION_JOBAO_42D05A_DBOPERATIONJOBThe Jira Bulk Issue Creation jobs, while they are executing.
AO_42D05A_TASKWe keep the old table.Status of the background migration tasks.

...