Create 'n' clones for an image
Published 27 February 2017
This script will create as many clone databases as requested on a given agent.
#Create ānā clones from image; Connect-SqlClone -ServerUrl 'http://sql-clone.example.com:14145' $myLocalAgent = "wks-dev1" $myLocalInstance = "Dev" $sqlServerInstance = Get-SqlCloneSqlServerInstance -MachineName $myLocalAgent -InstanceName $myLocalInstance $image = Get-SqlCloneImage -Name 'StackOverflow Jan 2017' $ClonePrefix = '_SO_Clone' $Count = 5 # or however many you want $elapsed = [System.Diagnostics.Stopwatch]::StartNew() "Started at {0}" -f $(get-date) "OK, going to create {0} clones" -f $Count for ($i=0;$i -lt $Count;$i++) { $image | New-SqlClone -Name $ClonePrefix$i -Location $sqlServerInstance | Wait-SqlCloneOperation "Created clone {0}" -f $i; }; "Total Elapsed Time: {0}" -f $($elapsed.Elapsed.ToString())