Install SqlPackage

This how-to will guide you on how to install the latest available SqlPackage onto your machine.

Prerequisites

• Machine with D365FO installed
• PowerShell 5.1
• d365fo.tools module installed
• d365fo.tools module loaded into a PowerShell session

Please visit the Install as an Administrator or the Install as a Non Administrator tutorials to learn how to install the tools.

Please visit the Import d365fo.tools module tutorial to see the different ways you can load the d365fo.module into a PowerShell session.

Install latest SqlPackage

Installation of the latest AzCopy is done with the Invoke-D365InstallSqlPackage cmdlet. Using this command will also update the internal path inside the module pointing to the SqlPackage.exe. Type the following command:

Invoke-D365InstallSqlPackage

images/howtos/Invoke-InstallSqlPackage.gif

Closing comments

In this how to we showed you how to install the latest SqlPackage.exe on your machine. By using the Invoke-D365InstallSqlPackage cmdlet, you also updated the path for the module where to look for SqlPackage.exe. If you just want to update the path for the SqlPackage.exe, you can look into the Set-D365SqlPackagePath cmdlet.