You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...
Your database environment is getting more complex. If that sounds like old hat, that’s because it is. For years, articles like this have warned of the dangers of increasingly convoluted database ...