I looked at this question. As far as I understand test env is for qa department to conduct their tests, and staging is identical to prod, but hidden from end user.
My questions are:
- Should staging be 100% identical to prod, or is it ok for staging to have "messed up" data in it? Just how much is it ok for staging db to differ from production db?
- Is it normal/standard procedure to copy tables from staging env to prod env? Is that how other companies do it in the real world?
Why am I asking (or where I am coming from)
I have a txt file and I have to dump contents of this file into database. We have 3 environments: dev, test, prod. I can dump data to dev, test but not prod. We are not allowed to dump data directly to prod database. We are only allowed to move data by requesting a database move. Then somebody will copy table from test to prod for me. My concern is that while doing testing in test db I may corrupt correctness of data, and if I submit db move document and it gets approved messed up data will make it to production database. I want to avoid this, obviously.