'How to handle data in development, staging and production databases?
If you have a local database, Staging/UAT database, Production database
1)Say 10 developers have the database script to generate the database (I'm using liquibase), how can the devs fill their local database and staging/UAT database with test data? The script only handles the creation of tables and does not import data to the local & Staging/UAT databases.
2)If I changed the tables in the local & Staging/UAT database (say breaking a big table into 2 tables) and created a database script for it. Then I apply the changes to the production database by running the script, how do I handle moving the data in the production database's big table into the production database's 2 tables?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|