Migration

About

Migration

Source Database Connection ▼

API Root URLs ▼

Shared Services Database Connection ▼

Clinical Portal Database Connection ▼

Integration Engine Database Connection ▼

Biometrics Engine Database Connection ▼

Survey Engine Database Connection ▼

Reporting Engine Database Connection ▼

One-time bootstrap: ensure the AMC Health master org + migration user exist so APIs can be called and downstream migrations have FK targets. Run only once on a newly built environment after 'Refresh Environment Configuration' and the databases have been built. Clicking this button more than once will not break anything.

Migration Options ▲

🔒 Every “Delete …” step below is disabled. The delete logic is unreliable and untested. To start from empty, use the per-database Rebuild Database buttons above and then run only the Migrate steps — do not reach for a delete step.

Re-enabling one is a code change, and it must be preceded by a logic review of that step’s delete confirming all three:

it clears only the tables loaded by the Migrate steps that follow it;
it resets the identity columns of every table it clears;
it does not cascade into tables that do not need to be cleared.

1. Delete shared services data (Reference)

2. Migrate shared services data (Reference) ~40 min

3. Delete shared services data (Core + Persons)

4. Migrate shared services data (Core + Persons) ~20 min Customers, Organizations, Programs, Config, Persons, SystemUsers (no passwords)

5. Update SystemUsers (all where password is NULL) ~3 min Lineage backfill + password hashing for all users missing legacy_password_enc

If set, bcrypt this password for ALL null rows (fast). If blank, decrypt each user's legacy password individually (slow).

6. Enable Single User Login Decrypt + bcrypt one user by legacy PersonId or username

6.1 — Create service accounts (smoke-test, team-admin) < 1 min Bulk-upsert seed system users via PUT /identity/system-users with permanentPassword (M2M *-service accounts retired — SS-21 SigV4)

6.2 — Create survey engine users (survey-admin, survey-staff) < 1 min Bulk-upsert 2 survey-engine system users (roleCode 200/201) via PUT /identity/system-users with permanentPassword

6.3 — Create CareEquipOps users (one per cel-* role) < 1 min Bulk-upsert 5 cel-* system users (cel-operator/manager/admin/finance/clinical) via PUT /identity/system-users, read_write at org_node 1. roleCode resolved from the seeded roles catalog by display_name. Re-runnable: creates only missing users, and restores an org.assignments row wiped by step 7.

7. Delete shared services data (11-29)

8. Migrate shared services data (11-29) ~11 min Phones, Emails, Addresses, Roles, Settings, NotificationGroups, Patients through Schedule

9. Delete files & notifications (30-37)

10. Migrate files & notifications (30-37) ~3 min ReferralProfile, UploadedFiles (deferred), Conversations (deferred), Messages (deferred)

11. Delete shared services notifications (N1, N2, N4)

12. Migrate shared services notifications (N1, N2, N4) ~1 min StaffNotifications, EmailNotifications, NotificationSchedules, MobileQueue

⚠ Before running any step below this line (any engine other than shared-services): re-enable reference-sync and confirm each engine's local reference.* tables are populated — run /enable-ref-sync, which re-enables the rules and invokes each consumer's reconcile. Re-enabling alone leaves consumers stale.

13. Delete clinical portal config data (C20-22)

14. Migrate clinical portal config data (C20-22) < 1 min

15. Delete clinical portal cases (C25)

16. Migrate clinical portal cases (C25) ~1 min Cases.Cases -> clinical.cases, builds caseMap

16.1 Migrate additional e-mail notifications (N5) Cases.AdditionalEMailNotifications -> notification.additional_email_notifications (shared_services). Runs here, not with 11-12, because it needs the caseMap step 16 builds. Cleared by checkbox 11.

16.2 Migrate mobile notification queue (N6) Cases.MobileNotificationQueue -> notification.mobile_notification_queue (shared_services). Runs here, not with 11-12, because it needs the caseMap step 16 builds. Cleared by checkbox 11.

17. Delete clinical portal case details (C26+)

18. Migrate clinical portal case details (C26+) ~25 min StatusHistory, ExternalIDs, CareManagers, CPT

19. Delete clinical portal case notes, faxes & attributes (C-CN1) — REQUIRED before 20

20. Migrate clinical portal case notes, faxes & attributes (C-CN2) ~15 min — run 19 first (MIG-55: 20 no longer clears the tables itself; running it alone appends and fails loud on duplicates) LogSentFaxes, Notes, NoteContacts, NoteContactMethods, NoteReasons, NoteInterventions, NoteResolutions, GroupNotes, NotesToGroupNotes

21. Delete integration engine data (IE1-4)

22. Migrate integration engine data (IE1-4) < 1 min

23. Delete survey engine data (S1-2)

24. Migrate survey engine data (S1-2) < 1 min

25. Delete biometrics tenant defaults (B1-4)

26. Migrate biometrics tenant defaults (B1-4) < 1 min thresholds, target ranges, weight variances, compliance regiments

27. Delete biometrics per-case config (B5-11)

28. Migrate biometrics per-case config (B5-11) ~15 min regiment groups, issue settings, alert thresholds, target ranges, weight/inhaler

29. Delete biometrics reading schedules (B12)

30. Migrate biometrics reading schedules (B12) ~2 hrs Cases.ReadingsSchedules -> config.readings_schedules (~37M rows; per-date expected-reading schedule)

31. Migrate biometrics DynamoDB readings (B19) ~16 hrs readings (Sessions + EAV -> JSON); runs independently of alerts

If set, seed the readings loop at this SessionId (aligned down to the 250,000 stride) instead of MIN(SessionId). Blank = start from the beginning.

32. Migrate biometrics DynamoDB alerts (B20) ~4.5 hrs alerts (SessionAlerts); runs independently of readings

33. Delete clinical portal announcements (A1)

34. Migrate clinical portal announcements (A1) < 1 min Reference.Announcements -> clinical.announcements (direct 1:1 copy, all rows)

Console Log (1 entries)

[3:34:56 PM] Switching VPC peering route to shared-services (pcx-00fd61dde5d307ba0)...

An unhandled error has occurred. Reload 🗙