• What we're doing is simple as long as you script your database changes from DEV to PROD. Here how it goes.

    1) We backup PROD database every day (week or month. Depends on your dev cycle)

    2) We restore PROD database into another database and run clean-up scripts (due to compliance on sensitive data)

    3) We backup cleansed database and port backup file(s) to DEV environment

    4) We restore cleansed PROD backup on DEV environment and run incremental script to bring PROD "data" to DEV schema.