Hey guys. I run a pretty big site off EE. This is great, except I’m wondering if there’s any decent way to push changes from a local build of the site to the live server without destroying data.
Obviously I can move the template files themselves and synchronize them, but what about changing configuration stuff? Right now, when testing, I just copy the entire database from one server to another, but that doesn’t work when the live server has hundreds more comments and such than my local build.
Any thoughts, other than just keeping a log of changes and manually also changing them on the live server?