Order of Ops

• Migrate existing DB to local VM

  → Desktop or NUC - pending RAM - Seaver to investigate

  • Copy existing DB
  • RBAC Adjustments
    • Destroy any non-user roles, using coolguy
    • Setup new user and top level scaffolding
    • New temp role for dual-db driver syncs
    • Introduce initial per-schema structure
  • Per Schema Migration Updates
    • Add new <platform> schema
    • Add new RBAC roles
    • Transfer table data

• Migrate to new Linode instance

  → High-Mem 24 GB / 2 Core

  • Obtain new VM; keep existing in parallel
  • New Postgres DB, with conf updates
  • RBAC for users, high level access (non program)
  • Migrate data in current state
  • Integrate dual-db driver for sync programs

• Transition to new, optimized schema

Task Ideation

Phase 1 - Estimate 50h* - 1 sprint

<aside> 💡

Move to new VM & foundational structure

</aside>

1. Store Tableau VC SQL Statements in Notion & Update Auth | Tam (Oscar) | 8h
2. Create & Store VC SQL in DB | Seaver | 3h
   1. Create temp-analytics schema
   2. Create / Update tableau service role for access
   3. Create View
3. Create New Tableau VC via SQL to temp-analytics | Tam (Oscar) | 16h
4. Conduct Migration Copy Enhancements via SQL Files | Seaver & Miles | 16h
   1. Copy DB Locally - 1h
   2. Write SQL files - 8h
   3. Validate End State - 2h
   4. Repeat if Needed - TBD
   5. Test service credential “happy path” - 2h
5. Migrate DB to New HM Linode VM | Seaver | 7h
   1. Initialize new HM VM - 2h
   2. Copy DB - 1h
   3. Apply SQL Batch - 1h
   4. Deploy Sync Program service role updates - 1h
   5. Adjust pg.kostorage.tech - 1h

Phase 2

<aside> 💡

Enhance & optimize existing DB foundational structure

</aside>

• Table layouts (columns, names)
• Metric table stance
• DB Plugins (TimescaleDB)