1

Installs sql server using commands line but I miss SqlPackage.exe. It's probably in one of the Feature Parameters, but unfortunately I don't know which one.

Probably this should create that path for sql server 2017:

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

Documentation with all Feature Parameters:

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-from-the-command-prompt?view=sql-server-ver15#Feature

1
  • 2
    Try downloading and installing sqlpackage separately. I don't think it's included with the SQL installation media. Commented Apr 21, 2020 at 11:53

1 Answer 1

5

SqlPackage.exe is not part of the SQL Server installation. It comes under SQL Server Data Tools team. You can download the Sqlpackage.exe using below link

SQLPackage.exe Download

Below is a excerpt from SQL Server Data Tools team blog

SqlPackage.exe is a command line tool that gives many of the same features used in SSDT (to publish, extract, import and export databases). If you want to take advantage of the latest features such as Azure Key Vault support for Always Encrypted in SqlPackage, we recommend you install the DacFramework.msi which includes all the Azure DLLs needed to connect and publish to Azure SQL DB.

  • SSDT will continue to install SqlPackage.exe in "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130" so that users running on build agents won't have scripts broken, but this will not have Azure support at present.
  • SSMS now has its own copy of DacFx, so updates to DacFramework.msi will not affect SSMS (and vice versa).
  • DacFramework.msi installs to "C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" and updates independently of SSDT / SSMS.
  • We will work to get an easier installation for future updates so you do not need an MSI to install SqlPackage.exe
Sign up to request clarification or add additional context in comments.

2 Comments

Is there any meaning that I have version 17.9.1 of SQL Server Management and Sql Server 2017? I cant find other version then this from link.
Sql Server management tool version is different from SQL Server version. SSMS is standalone tool. You can download latest version from here: <learn.microsoft.com/en-us/sql/ssms/…>. It is currently 18.5. For SQL Server, latest version is SQL Server 2019 ie., SQL Server version 15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.