A client has asked us if its possible to preview content changes on a Staging site and then when it's ready to be published, it would appear on the Production site without having to re-key all of the content and asset uploads/changes.
I wondered if anyone has looked into this kind of Content staging with ExpressionEngine before?
I know that some other CMS' have something similar, but i'm not aware of anything out of the box with EE.
Typically, we run the usual Local/Dev, Staging and Production environments and we regularly migrate a copy of the Production database over to Local and Staging so that they're in sync which helps when we're working on new features.
Our client also tests out content changes on the staging site, for example when they have a new season campaign.
I know that there are also some workflow add-ons that would have preview versions of content on the Production site as well, so this might be the route to take.