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

amrnrhlw 于 2023-06-28 发布在其他

关注(0)|答案(6)|浏览(114)

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

sql-server

来源：https://stackoverflow.com/questions/50479660/sqlpackage-exe-is-not-recognized-as-an-internal-or-external-command-error

6条答案

按热度按时间

piv4azn71#

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

赞(0）回复(0）举报 2023-06-28

rqmkfv5c2#

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,

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;"

赞(0）回复(0）举报 2023-06-28

aamkag613#

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）回复(0）举报 2023-06-28

iih3973s4#

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）回复(0）举报 2023-06-28

8fq7wneg5#

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）回复(0）举报 2023-06-28

iecba09b6#

try following: