-
Notifications
You must be signed in to change notification settings - Fork 0
Invoke D365InstallSqlPackage
Download SqlPackage.exe to your machine
Invoke-D365InstallSqlPackage [[-Path] <String>] [-SkipExtractFromPage] [[-Url] <String>] [<CommonParameters>]
Download and extract the DotNet/.NET core x64 edition of the SqlPackage.exe to your machine
It parses the raw html page and tries to extract the latest download link. As of 12th April 2022, no .NET Core link is available on the download page. The cmdlet will always use the Url parameter.
Invoke-D365InstallSqlPackage
This will download and extract the latest SqlPackage.exe. It will use the default value for the Path parameter, for where to save the SqlPackage.exe. It will try to extract the latest download URL from the RAW html page. It will update the path for the SqlPackage.exe in configuration.
Invoke-D365InstallSqlPackage -Path "C:\temp\SqlPackage"
This will download and extract the latest SqlPackage.exe. It will try to extract the latest download URL from the RAW html page. It will update the path for the SqlPackage.exe in configuration.
Invoke-D365InstallSqlPackage -SkipExtractFromPage
This will download and extract the latest SqlPackage.exe. It will rely on the Url parameter to based the download from. It will use the default value of the Url parameter. It will update the path for the SqlPackage.exe in configuration.
Invoke-D365InstallSqlPackage -SkipExtractFromPage -Url "https://go.microsoft.com/fwlink/?linkid=3030303"
This will download and extract the latest SqlPackage.exe. It will rely on the Url parameter to based the download from. 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: 1
Default value: C:\temp\d365fo.tools\SqlPackage
Accept pipeline input: False
Accept wildcard characters: False
Instruct the cmdlet to skip trying to parse the download page and to rely on the Url parameter only
Type: SwitchParameter
Parameter Sets: (All)
Aliases:
Required: False
Position: Named
Default value: False
Accept pipeline input: False
Accept wildcard characters: False
Url/Uri to where the latest SqlPackage download is located
The default value is for v19.1 (16.0.6161.0) as of writing. This is the last version of SqlPackage based on .NET Core. According to the Microsoft documentation, a .NET Core version of SqlPackage should be used. https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/import-database Further discussion can be found here: https://github.com/d365collaborative/d365fo.tools/issues/708
Type: String
Parameter Sets: (All)
Aliases:
Required: False
Position: 2
Default value: Https://go.microsoft.com/fwlink/?linkid=2196334
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)
- Install as a non-Administrator
- Install as a Administrator
- Import d365fo.tools module
- List available commands from d365fo.tools module
- Get help content for a command
- Start, Stop and List services
- Import users into the D365FO environment
- Import external users into the D365FO environment
- Enable users in the D365FO environment
- Update users in the D365FO environment
- Provision D365FO environment to new Azure AD tenant
- Import a bacpac file into a Tier1 environment
- List modules / models
- Compile module
- Install AzCopy
- Install SqlPackage
- Install Nuget
- Speed up LCS download via AzCopy
- Download latest bacpac from LCS via AzCopy
- Register NuGet source
- Configure Azure Logic App
- Fix AzureStorageConfig
- Run a runnable class
- Update users in environment
- Work with Azure Storage Account
- Work with packages, resource label files, language and lables
- Working with the different D365 services