The Development Life Cycle - How do you setup your environment?

I'm publishing my App to production and I need to split my PROD/DEV environment. I've been reading the documentation trying to wrap my head around the best alternative, but nothing conclusive at this point. Bellow is the scenarios I'm trying to solve:
Scenario 1 > I need to create a new field on an existing table and change the datatype of another field from numeric to string.

For this scenario I thought the same workspace: Use branch V2 to develop my API's and set the header: Http header X-Branch: v2 and X-Data-Source: test , and enable the test database.

The problem is I cannot change the table structure on the test (It's read only!) and neither in PROD (Too dangerous) I thought about duplicating the workspace, but in this case I need to do the same work twice.

How do you guys would solve this?๐Ÿ™ƒ

Other
1 reply