sql-serverenvironment-variablessqlpackage

'sqlpackage.exe' is not recognized as an internal or external command Error

I used maven,Microsoft SQL server management studio 17.SQL server verion is 14.0.1000.169. When i build my project it gives following error and build failed

'sqlpackage.exe' is not recognized as an internal or external command,
operable program or batch file.
[ERROR] The following errors occured during execution:
[ERROR] 'sqlpackage.exe' is not recognized as an internal or external command,
[ERROR] operable program or batch file.

This is my system environment path variables. enter image description here

I can't find what's the wrong

Solution

  • It's fixed using following steps.

    this is because you haven't sqlpackage.exe in your Path variables. to fix this follow below steps.

    You need to Install Sql server data tools

    For windows,

    For Install chocolatey

    For Install SSDT components

    For Add sqlpackage.exe to classpath