Hi,
I have to make adjustments on a webapplication very often. This app is used for our production and it is important that it's always available (without bugs).
Therefore I need to copy de DB to a Test DB, to develop and key users have a chance to test the new version.
But after the testingphase all changes made on the Test DB (fields added, changed...), I have to make on the Live DB.
Then I have to make sure offcourse that I didn't forget anything.
Is there a better way to do this?
Copy the data form Live DB to the Test DB is not possible because of the ID's that have been added to the Live DB while developping.
Your insights please..
Thx
Loading
Mahesh ChandPosted Sep 10, 2007, 8:12 AM
1. You need to write a document with evert change you make in your DEV environment
2. Take backup of your live PROD data
3. Make changes to your TEST env and test if every thing works fine
4. Shutdown your PROD and make changes
5. If problems, restore your backup until you fix the problem