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

Question

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.

I can't find what's the wrong

Answer 1

I didn't have the location of sqlpackage.exe in the PATH variable. After adding it to PATH variable, had resolved the issue for me. (Something like below)

C:\Program Files\Microsoft SQL Server\140\DAC\bin

Answer 2

It's fixed using following steps.

You need to Install Sql server data tools For that follow this steps.

For windows,

• Install chocolatey
• Install SSDT components
• Add sqlpackage.exe to classpath

For Install chocolatey

• https://chocolatey.org/install

For Install SSDT components

• choco install sqlserver-cmdlineutils

• choco install sql2014.clrtypes

• choco install sql2014-sqldom

• choco install sql2014-dacframework

For Add sqlpackage.exe to classpath

• RUN setx PATH "%PATH%;C:\Program Files\Microsoft SQL Server\120\DAC\bin\;"

Answer 3

Looks like you havn't installed Data-tier Application Framework. You can download and install DacFx (17.4.1) from https://www.microsoft.com/en-us/download/details.aspx?id=56508