Download SqlPackage.exe to your machine

Invoke-D365InstallSqlPackage [-Path <String>] [-Url <String>] [<CommonParameters>]

Invoke-D365InstallSqlPackage [-Path <String>] [-Latest] [<CommonParameters>]

Download and extract SqlPackage.exe to your machine.

Invoke-D365InstallSqlPackage

This will download and extract SqlPackage.exe. It will use the default value for the Path parameter, for where to save the SqlPackage.exe. It will update the path for the SqlPackage.exe in configuration.

Invoke-D365InstallSqlPackage -Path "C:\temp\SqlPackage"

This will download and extract SqlPackage.exe. It will save the SqlPackage.exe to "C:\temp\SqlPackage". It will update the path for the SqlPackage.exe in configuration.

Invoke-D365InstallSqlPackage -Latest

This will download and extract the latest SqlPackage.exe. It will use https://aka.ms/sqlpackage-windows as the download URL. It will update the path for the SqlPackage.exe in configuration.

Invoke-D365InstallSqlPackage -Url "https://go.microsoft.com/fwlink/?linkid=3030303"

This will download and extract SqlPackage.exe. It will rely on the Url parameter to base the download on. It will use the "https://go.microsoft.com/fwlink/?linkid=3030303" as value for the Url parameter. It will update the path for the SqlPackage.exe in configuration.

Path to where you want the SqlPackage to be extracted to

Default value is: "C:\temp\d365fo.tools\SqlPackage\SqlPackage.exe"

Type: String
Parameter Sets: (All)
Aliases:

Required: False
Position: Named
Default value: C:\temp\d365fo.tools\SqlPackage
Accept pipeline input: False
Accept wildcard characters: False

Overrides the Url parameter and uses the latest download URL provided by the evergreen link https://aka.ms/sqlpackage-windows

Type: SwitchParameter
Parameter Sets: ImportLatest
Aliases:

Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False

Url/Uri to where the SqlPackage download is located

The default value is for version 162.2.111.2 as of writing.

Further discussion can be found here: https://github.com/d365collaborative/d365fo.tools/discussions/816

Type: String
Parameter Sets: ImportUrl
Aliases:

Required: False
Position: Named
Default value: Https://go.microsoft.com/fwlink/?linkid=2261576
Accept pipeline input: False
Accept wildcard characters: False

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Author: Mötz Jensen (@Splaxi) Author: Florian Hopfner (@FH-Inway)