How to refresh dev image/clones with freshest prod data?

billfrench

Hello!  I've successfully made an image and a clone, and got it working in the app.  How can i now refresh this image / clone with the latest data from the original production database?  I tried searching, seems there's ways to automate it, but I want to do it manually as needed.  Thanks!

squigley

Good Afternoon!
First we would recommend creating a new fresh image via the SQL Clone Server. Afterwards you can just run the following powershell script manually to update all of the clones involved with the image:
https://documentation.red-gate.com/clone/automation/powershell-worked-examples/refresh-all-clone-databases-to-use-an-updated-image

Please let me know if you need anything else.

Thanks!