CODEWITHSUNDEEP
sql-servercmdcommand-line
Mat Rat
Mat Rat

Reputation: 125

Install sql server with component SqlPackage.exe

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

Upvotes: 1

Views: 9002

Answers (1)

Venkataraman R
Venkataraman R

Reputation: 13009

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

Upvotes: 5

Related Questions