Skip to content

Update business identifier sequence numbers in dev/test #34064

Description

@argush3

As a part of the data migration process, businesses for a given batch are dry-runned in modern dev/test environments. In the cases where business identifiers collide with businesses created in the modernized system, they are deleted first. This deletion causes a problem where data previously setup for things like UAT and other testing purposes are lost.

To avoid this problem of lost data for newly created businesses in dev/test, the proposed solution is to increment the business identifer sequence numbers in dev/test. We will increment the business identifier to be significantly higher than what is in prod currently which will give us a large enough buffer to never collide with businesses that are dry-runned into dev/test.

It should be noted that for businesses created in modern dev/test before the business identifier bump, businesses could still be deleted as migration batch dry-runs occur.

Tasks

  • Create script to bump business identifier sequences in cdev/ctst.
  • Home team runs script in cdev/ctst Received approval that data migration team can run script ourselves in cdev/ctst
  • Verify sequence numbers are updated in cdev/ctst
  • Verify we are able to create new businesses in dev/test and that business identifers have been bumped

Metadata

Metadata

Assignees

Labels

Entities - Data MigrationA label to filter on the tickets for the Entities Data Migration effort

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions