SQL Clone 3

Create 'n' clones for an image

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


Didn't find what you were looking for?