Restoring Production DB backup image to Staging DB pre-deployment

So this is a pretty simple questions with a lot of possible answers / opinions.

How would you go about implementing a once off data replication of Production, into Staging prior to a release?

Right now i’m looking at ensuring my staging environment is up to date prior to a deployment, so that I can:

  • Ensure any prior testing data / changes are wiped
  • Ensure Prisma Migrations are tested against a DB with real data, prior to release
  • Provide an environment for staff to run their daily activities alongside production as an extra layer of testing

As always if this sounds like a horrendous idea, I’m all ears.