Maintaining a production application while preserving production data
I have separate production and development environments. Is there any way to move fixes and enhancements into a prod environment without disturbing the prod data?
This is how I have been doing it - seems onerous:
- Export prod data to "Prod Backup" directoy
- Copy application from Prod to Dev environment
- Apply changes and test in Dev environment
- Delete data from tables and import from "Prod Backup"
- Move application back to prod environment