I have a problem with WordPress database synchronization between development and production and I am wondering how other people solving it. I am aware about this question but it doesn't really cover the nastier and more realistic use case.
Say I have a live WordPress website. I took a dump of everything, replicating it on our dev environment. I started making changes. 1 week later I am ready to deploy my updates. In the meantime, database on production site has changed(new posts, new comments, etc.). How do I synchronize changes between production and development during the rollout and is it possible to automate(somewhat at least) this process?