Production upgrades - best method?
Posted: Tue 21. Mar 2006, 19:58
Hi all.
I've got a production site running 1.2.4-DEV, and I have a local version (my development version) as well.
Typically, I make all my changes to the local copy, and then when it comes time to upgrade production, I export the "article", "article_content" and "file" tables, and import them on production.
That's worked fine until lately. Now, on production, the customer has the ability to modify their own articles - change some static pages, add news items, etc. Which is great, that's what they want to do and it means I don't have to do trivial changes for them anymore.
Problem is, now how do I update production? If I make structure or content changes on my local copy, I can't export/import because it will overwrite the changes they've made in production (which of course I don't have on my local copy).
How do the rest of you get around this problem?
What method do you use to upgrade production?
How do you merge or integrate changes you've made locally, with changes the customer has made on production?
Thanks for any advice.
PS: My 2 PHPWCMS websites are:
http://www.gosfordnetball.com.au
http://www.iceinspace.com.au
Cheers
Mike
I've got a production site running 1.2.4-DEV, and I have a local version (my development version) as well.
Typically, I make all my changes to the local copy, and then when it comes time to upgrade production, I export the "article", "article_content" and "file" tables, and import them on production.
That's worked fine until lately. Now, on production, the customer has the ability to modify their own articles - change some static pages, add news items, etc. Which is great, that's what they want to do and it means I don't have to do trivial changes for them anymore.
Problem is, now how do I update production? If I make structure or content changes on my local copy, I can't export/import because it will overwrite the changes they've made in production (which of course I don't have on my local copy).
How do the rest of you get around this problem?
What method do you use to upgrade production?
How do you merge or integrate changes you've made locally, with changes the customer has made on production?
Thanks for any advice.
PS: My 2 PHPWCMS websites are:
http://www.gosfordnetball.com.au
http://www.iceinspace.com.au
Cheers
Mike