We have a code, content and DB flow that follows a typical pattern:
The kicker is that the client is editing and publishing content only in Prod.
So our current strategy is to attempt to do a full content sync Prod->Staging on a semi-regular basis and then a full sync Prod->Build/Dev on an ad-hoc basis. Doing a Prod->Build/Dev push means the environment is unusable for a period of time (at least a day).
What strategies exist to make sure your dev/test/build environments accurately match prod in terms of content and how are others managing this problem?
We are using Sitecore 6.1 as the CMS system