Here is the scenario...
We have a blog where user can comment, but we will require the comment to be approved before it is shown. This will require data(comment) sync from production server to our staging server, where our business user can approve the comments before syncing approved comment back to production server.
I understand that site sync is one way, so can someone recommend how the workflow should be in this case or the best way of solving this problem? It is simply too labor intensive if we need to do database restore from production to staging everytime there is new comment coming in.