Migration

Source Database Connection ▼

API Root URLs ▼

One-time bootstrap: ensure the AMC Health master org + migration user exist so APIs can be called and downstream migrations have FK targets. Run once per environment after deploy.

Shared Services Database Connection ▼

Clinical Portal Database Connection ▼

Integration Engine Database Connection ▼

Biometrics Engine Database Connection ▼

Survey Engine Database Connection ▼

Reporting Engine Database Connection ▼

Logistics App Database Connection ▼

Migration Options ▲

1. Delete shared services data (Reference)

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

3. Delete shared services data (Core + Persons)

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

5. Update SystemUsers (all where password is NULL) 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, *-service, team-admin) Bulk-upsert 8 system users via PUT /identity/system-users with permanentPassword

7. Delete shared services data (11-29)

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

9. Delete files & notifications (30-37)

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

11. Delete shared services notifications (N1-4)

12. Migrate shared services notifications (N1-4) 1 min StaffNotifications, EmailNotifications, NotificationSchedules, MobileQueue

13. Delete clinical portal config data (C1-15, C20-23)

14. Migrate clinical portal config data (C1-15,C20-23) < 1 min

15. Delete clinical portal cases (C25)

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

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 & attributes (C-CN1)

20. Migrate clinical portal case notes & attributes (C-CN2) ~15 min 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-12)

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

29. Delete biometrics archive (B13-18)

30. Migrate biometrics archive (B13-18) — no-op archive tables grow organically via API; nothing to migrate

31. Delete biometrics DynamoDB (B19-20) readings + alerts; recreates tables rather than TRUNCATE

32. Migrate biometrics DynamoDB (B19-20) ~15 min readings (Sessions + EAV -> JSON) + alerts (SessionAlerts)