I'm about to embark on developing a tool that allows you to diff and merge two WordPress exports. Before I go committing a big effort in this, I'd like to know it's not already out there. I've searched high and low but couldn't find anything.
My motivating user story is this:
As a WordPress admin, I want to be able to easily add or update objects (Posts, Pages, Attachments, Navigation Menu Items, FAQs) in my "Dev" instance from objects in my "Prod" instance so that I can quickly launch new versions of the website.
I've looked at the DB schema and quickly realized that there are all kinds of assumptions/relationships encoded within WordPress that it would be a tall order to replicate that (and keep it consistent across WP versions). I'm assuming that the XML in the export is the best expression of a logical model.
Know of any good WP export diff/merge tools?
