I have development and production versions of my website (on the same hosting). I want to easily synchronize the content between these versions. On the production website, content is updated daily.
I cannot use the XML export function because duplicate posts would be created on the development website.
Currently both websites uses different databases, but if there is a solution that allows for usage of only one database I gladly will go through it.