Install dbatools on a computer without internet access

[andreasjordan]

If you need to install dbatools on a computer without internet access, you only need two files: The NuGet-DLL and the dbatools-NuGet-package.

You can get the NuGet-DLL Microsoft.PackageManagement.NuGetProvider.dll from any other system where you installed NuGet with an internet connection or download it from: https://onegetcdn.azureedge.net/providers/Microsoft.PackageManagement.NuGetProvider-2.8.5.208.dll and rename the file.

You download the dbatools-NuGet-package from https://www.powershellgallery.com/packages/dbatools using the "Manual Download":

Then you need to transfer those two files to the target computer and only have to change the following code to your needs:

$nugetPath = "$($env:ProgramFiles)\PackageManagement\ProviderAssemblies\NuGet\2.8.5.208"
$null = New-Item -Path $nugetPath -Type Directory
Copy-Item -Path .\Microsoft.PackageManagement.NuGetProvider.dll -Destination $nugetPath

$repoPath = "C:\Temp\MyPSGallery"
$null = New-Item -Path $repoPath -Type Directory
Copy-Item -Path .\dbatools.1.1.38.nupkg -Destination $repoPath
Register-PSRepository -Name MyPSGallery -SourceLocation $repoPath -PublishLocation $repoPath -InstallationPolicy Trusted

Install-Module -Name dbatools -Repository MyPSGallery
Import-Module -Name dbatools
Get-Module -Name dbatools

Let me share my screenshot as a proof of concept:

I worked in a remote session on a windows server core, so to run it locally you probably need an elevated PowerShell.

See also my blog post for even more information: https://blog.ordix.de/installation-and-use-of-dbatools-on-a-computer-without-internet-connection

[nanoDBA]

Thank you for taking the time to write this up and share it here from your original excellent tweet. Much appreciated!

[andreasjordan]

You want to update dbatools to a new version? No problem. Just download the new nupkg file and place it next to the old in you local repository. Then you can use Update-Module -Name dbatools to install the new version.

[potatoqualitee]

Awesome, thank you so much andreas!

[andreasjordan]

See also my blog post about that: https://blog.ordix.de/installation-and-use-of-dbatools-on-a-computer-without-internet-connection

[bneal1987]

Walking through this I am getting an error and was hoping you could assist with this.

Thanks,

[bneal1987]

Any ideas on the above error?

Thanks,

[andreasjordan]

Sorry, no. The first error tells you that the directory is already there - so NuGet might already be set up correctly. You probably should not have copied the ddl there. The second error tells you that the command Register-PackageSource is different from what we expect, as the property SourceLocation is not found. Looks like your environment is different than mine - so the code will not help you.

[bneal1987]

Thanks you for the quick response on this!