Schema change to multiple base

[NICKNAME]

When you have multiple independent instances of the same database schema (Base) along with their corresponding user interfaces (UIs) and separate data records, you might be looking for efficient methods to implement changes to the database schema or UI across all these instances. What strategies or solutions are available for applying updates or modifications to the database schema or the UI consistently and effectively to all instances?

To provide some illustrative context. I would like to add a Field 3 to the Master-BASE and rollout this change to all instances.

MASTER-BASE

• Table A
  • Field 1 (Single Line)
  • Field 2 (Number)
• Table B
  • Field 1 (Email)

MASTER-UI

• View 1

Instance1-BASE

• Table A
  • Field 1 (Single Line)
  • Field 2 (Number)
• Table B
  • Field 1 (Email)

Instance1-UI

• View 1

Instance2-BASE

• Table A
  • Field 1 (Single Line)
  • Field 2 (Number)
• Table B
  • Field 1 (Email)

Instance2-UI

• View 1

Thank you