Database migrations

[revnelson]

Hello beautiful community. I've been developing a website that is close to launch using payload for the CMS. One issue I'd love some clarity on is how to safely and sanely manage changes to the schema in production. When developing, simply saving the config files is enough to change the database so it seems like I definitely need to clone the database and do development on a "dev" database. Once I'd like to push those changes to production, what is the method? Can somebody outline the process in pseudo code? Maybe for example a user collection where I'm changing a name group field with first and last fields in the group to firstName and lastName fields on the root of the user collection. I really don't have a grasp on what can be done with the migrations function in the documentation. Is this what I'm looking for, or is this used for moving between MongoDB and Postgres? Thank you in advance!