Usecase:
Migrate all data related to a tenant (discriminated by tenant-id) to a dedicated Database schema.
Context: tiers in a cloud installation:
- in a small / free tier, multiple tenants share the same database schema.
- As a tenant switches to an advanced tier, they are moved to a dedicated schema.
Open Questions:
- this process probably requires downtime
- new schema inside the same database or dedicated database?