brianfromme

Here is the process I believe is required:

1. Copy the DB from production to dev.
2. Begin enhancements, and/or bug fixes.
3. Test.
4. Release – extra work is needed here:

• Freeze the production DB for as short a period as possible (i.e. seconds)
• Copy the production DB to staging.
• Merge changes from the Dev DB into staging.
• OPT: It might make sense to do a sanity test here.
• Copy the staging DB to production.
• Unfreeze the production DB.
• NOTE: this assumes the code is also released to production.

• Finally, runs some test on the new production system.