deploy
Sync Staging (From Staging to Production as Simply as Possible)
Problem
To me a staging server is one where I try new modules, make settings changes, and otherwise screw around with the data structures. A production server holds the content, interacts with my users, etc.
My problem is when I need to create a staging server (by dumping the production server database) it immediately goes out of sync with the production server.
How to find what db tables are changed for each module OR how to deploy and maintain a live site
Is there an easy way of finding out what db tables are changed for each module?
I'm asking because I'm trying to figure out how to deploy and maintain my website. The live version is a community website, so users will be adding content. On the development side, I'll be making changes. I need to figure out if there's a way to only deploy the setting changes to the live version, so I don't clobber data the users have added. I'd rather not put the live site into maintenance mode as I fiddle with changes, and I certainly would like to avoid making changes to the live site while its live.
