What are the challenges you face when working across database platforms? Take the survey
Options

List All Clones

Right now the only way through WebUI to view a list of clones is to go to each image. Would it make sense to have a clone listing view that you could see all clones and their related image? I know I can get this with PowerShell, but do not always have that running. For instance this morning I was verifying everything came back online after patching it would have been nice to be able to load a view that showed all clones and their online status to get a quick look that all is good.
Tagged:

Answers

  • Options
    Makes sense to me! I'll raise this with the team.

    When you say patching, is that when patching SQL Clone itself and its agents?
    Software Engineer
    Redgate Software
  • Options
    We patch the OS monthly. So Windows patches are applied the servers are rebooted. I had a lot of issues in the beginning of SQL Clones release that the order in which things came up caused issues with clones hosted on other servers. This has not been an issue with the latest versions. I patch SQL Clone manually since we have issues with certificate authorizations. Wish there was something you could do about that.
  • Options
    $redgateCloneURL = 'http://devclndbs01.exclaim-dev.com:14145'
    Connect-SqlClone -ServerUrl $redgateCloneURL
    
    $imagelist = Get-SqlCloneImage
    $clonelist = Get-SqlClone
    
    foreach ($name in $imagelist) {
        $clonelist | Where-Object ParentImageId -EQ $name.Id | Select-Object @{Name="Image Name";Expression={$name.name}}, Name, State
    }
    
    $clonelist = Get-SqlClone
    


    I put this code together. Do you know how I can return the located on server that the clone is hosted on? I could not figure out how to capture this server name.
  • Options
    Would something like this do the job?
    $allSqlServerInstances = Get-SqlCloneSqlServerInstance
    
    $myClone = Get-SqlClone -Name MyClone
    
    $myCloneInstance = $allSqlServerInstances | Where-Object Id -Eq $myClone.LocationId
    
    Software Engineer
    Redgate Software
Sign In or Register to comment.