If all or nothing is to restore a database dump from dev to prod then supported selective would be
- XOGing what can be xoged
- manually doing what cannot be xoged
Unsupported would be direct changes in db
Additionally there may be "configuration" of the Clarity files. They would have to be copied manually again vs backup and restore.