dbatools-buildref-index.json Out Of Date

[IanPaulTurner]

I notice that the online (https://sqlcollaborative.github.io/assets/dbatools-buildref-index.json) doesnt contain details of the latest SQL2016 and SQL2017 patches.

Cumulative Update 10 for SQL Server 2016 SP2
Cumulative Update 17 for SQL Server 2017

Is there anyway of executing Update-DbaInstance without it checking this file?

Example Command

Update-DbaInstance -ComputerName $ServerName -Restart -Path $PathToUpdates -Credential $Creds

14.0.3223 on computer [SERVERNAME] is already the latest available

[wsmelton]

The command does not check the online site. It checks the json file locally in the module that we ship with it.

[wsmelton]

The file is current as well on the site.

https://github.com/sqlcollaborative/sqlcollaborative.github.io/blob/master/assets/dbatools-buildref-index.json

[wsmelton]

To get an update of that file you will need to update the module on your server or machine.

[afzaalazizawan]

Hi all,

I normally use Update-DbaInstance in my powershell script to apply lates update on my sql estate.
I also run Get-DbaBuildReference -Update within the script to get buildreference updated event I updated dbatools.

But it still lacks information of latest updates released in past few days -- after a week or 2 it gets updated.

I have to apply the patch as soon it releases is there any way we can get buildrefence updated

I did try to add latest patch information in But the "C:\Program Files\PowerShell\Modules\dbatools\2.1.25\bin\dbatools-buildref-index.json" but it does not work.

Would appreciate for any advice on above. (summary: how to update buildreference manually for latest sql updates)

[niphlod]

there's a PR ready (#9493), it'll be fine.