Published 01 May 2018
SQL Clone can modify your clones while they are being created by applying a clone template to them via PowerShell (as of version 2.6.0) and via the GUI (as of version 2.6.1).
SQL Clone templates contain a collection of T-SQL scripts that will be run on a clone, in sequence, just after it is created. As with T-SQL image modifications, the scripts will be run as a limited user.
Each template belongs to an image. Each image can have multiple templates available from it, but each clone can only have one template applied to it.
Suppose you have an image in which you want to clone, but each clone may have different requirements. Creating multiple images could be time consuming and so it may be quicker and easier to have create modified clones based upon your image.
Using the clone modifications feature, a template will update the clone. This all happens as a part of the clone creation workflow - no additional manual work needed, except to specify what work to do.
Specifying modifications via the web UI
During the clone creation workflow, SQL Clone will give you the option of choosing a template that will be used to modify your clone. If you don't choose a template, your clone will be created as normal.
Specifying modifications via PowerShell
See our reference page and usage examples.