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())