These pages cover SQL Clone 3, which is not the latest version. Help for other versions is also available.
Create a clone on all connected SQL Server instances
Published 24 February 2017
You may have a scenario in which you want a 'latest' copy of a database to be available on all SQL Server instances which are registered with SQL Clone.
- Connect-SqlClone -ServerUrl 'http://sql-clone.example.com:14145'
- $SourceDataImage = Get-SqlCloneImage -Name 'ImageName'
- $CloneName = 'ImageName_Latest'
- # I have multiple SQL Server instances registered on my SQL Clone Server - I want to deliver a copy to all of them
- $Destinations = Get-SqlCloneSqlServerInstance
- # Start a timer
- $elapsed = [System.Diagnostics.Stopwatch]::StartNew()
- "Started at {0}, creating clone databases for image ""{1}""" -f $(get-date) , $SourceDataImage.Name
- foreach ($Destination in $Destinations)
- {
- $SourceDataImage | New-SqlClone -Name $CloneName -Location $Destination | Wait-SqlCloneOperation
- $ServerInstance = $Destination.Server + '\' +$Destination.Instance
- "Created clone in instance {0}" -f $Destination.Server + '\' + $Destination.Instance;
- }
- "Total Elapsed Time: {0}" -f $($elapsed.Elapsed.ToString())