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 ▼

Migration Options ▲

Delete shared services data (Reference)

Migrate shared services data (Reference) ~23 min

Delete shared services data (Core + Persons)

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

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).

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

Delete shared services data (11-29)

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

Delete files & notifications (30-37)

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

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

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

Delete clinical portal cases (C25)

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

Delete shared-services notifications (N1-4)

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

Delete clinical portal case details (C26+)

Migrate clinical portal case details (C26+) 18 min StatusHistory, ExternalIDs, CareManagers, Notes, Issues, CPT

Delete integration engine data (IE1-4)

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

Delete survey engine data (S1-2)

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

Delete biometrics tenant defaults (B1-4)

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

Delete biometrics per-case config (B5-12)

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

Delete biometrics archive (B13-18)

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

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

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