Hey everyone! I'm diving into backend development and am curious about how companies handle schema changes.
Specifically, do you use migration tools like Liquibase or Flyway for making schema updates before merging to staging and then to production? Also, is it ever acceptable to manually change the schema using tools like MySQL Workbench, or should that be avoided altogether?
1 Answer
It's pretty much a must to use migration tools for schema changes. Manually altering the production database is a big no-no in any professional setting—it's risky and can lead to pretty severe issues.
Thanks! I might be overthinking it here, but what's the usual process for getting test data aligned with the new schema after a migration? Is it just:
1) Make changes with the migration tool.
2) Populate with fake data for local testing.
3) Merge to staging.
4) Finally, merge to production? Am I missing anything?