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

4
votes

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

6
sql-serverenvironment-variablessqlpackage
Please do not add the sql tag to your question: there is no SQL query involved in your question. And "SQL" is not the same as "Microsoft SQL Server". – a_horse_with_no_name
I just got the same problem. Even though my path was in the env it was saying is not recognized... It is case sensitive once I put SqlLocalDB.exe all good. – virtualdvid

6 Answers

4
votes

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

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\;"
2
votes

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
1
votes

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

0
votes

Download Microsoft SQL Server Data-Tier Application Framework from https://www.microsoft.com/en-us/download/details.aspx?id=56508 and open Environment settings and set the PATH variable to C:\Program Files\Microsoft SQL Server\140\DAC\bin

0
votes

Adding these locations into path variable will fix both maven and gradle error if you already installed mssql server 2019.

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin

C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\130\Tools\Binn

0
votes

try following:

  1. install https://dotnet.microsoft.com/download/dotnet/3.1
  2. install https://docs.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver15
  3. run this command in terminal in projects directory(without braces) "dotnet add package Microsoft.SqlServer.DACFx"