Copy existing images
Is is possible to copy an image with creating it again from a backup?
We would like to have a process where we have a nightly process for creating images from the latest production backups. Then, at selected times, developers can clone these databases. But if they clone the images that we generate every night, it won't work since we either can't overwrite the image or we have to first delete the image and all it's clones.
Ideally we want a way to create a copy of the latest image of each database and then create a clone from the image instead. That way, the "latest" images will be not be cloned directly.
Has anyone done anything similar or have some recommendations?
Thanks
/Jakob
We would like to have a process where we have a nightly process for creating images from the latest production backups. Then, at selected times, developers can clone these databases. But if they clone the images that we generate every night, it won't work since we either can't overwrite the image or we have to first delete the image and all it's clones.
Ideally we want a way to create a copy of the latest image of each database and then create a clone from the image instead. That way, the "latest" images will be not be cloned directly.
Has anyone done anything similar or have some recommendations?
Thanks
/Jakob
Answers
We don't currently have a feature to copy images, but it is possible to rename images in SQL Clone, which can be automated:
https://documentation.red-gate.com/clone4/automation/powershell-cmdlet-reference/rename-sqlcloneimage
You could use this to maintain a consistent name for the current image, which gets updated when a new image is available (and old images are renamed until their clones are removed and they can be cleaned up).