27

I am trying to use the SQL Package command-line utility (sqlpackage.exe) on a SQL Server, but I cannot find it anywhere online.

Is it something that I can download as a standalone utility, or is it part of some greater software bundle that I have to install?

15

Standalone downloads are available from Microsoft.

It's also included in the "SQL Server Data Tools" from Microsoft.

SQL Server Data Tools proves command-line tools that enable a number of project-oriented database development scenarios.

More info from MS here.

You can download the "SQL Server Data Tools" from MS here.

| improve this answer | |
  • Is there a version which doesnt come with visual studio ? – Mark Broadhurst Mar 31 '15 at 14:22
  • @SaintGerbil I'm not sure what you mean? The downloads on the linked page do not include Visual Studio. – Ƭᴇcʜιᴇ007 Mar 31 '15 at 14:51
  • On installing "SSDTSetup.exe" you get an error towards the end "this application requires Microsoft Visual Studio. Install Microsoft Visual Studio and run the installer again." where I want to install it on a server which has a SQL 2008 R2 and no VS so I want to be able to run the tools (like sqlpackage.exe) without all the designer files. – Mark Broadhurst Apr 1 '15 at 8:50
  • 3
    @SaintGerbil You want the "Microsoft SQL Server Data-Tier Application Framework" (aka "DACFx") At the moment, the May 2015 version is the latest. (MS does a terrible job with organizing their downloads - It's almost impossible to confirm what the latest version of anything is...) – CrazyPyro Dec 14 '15 at 21:41
  • 4
    I find it frustrating that I have to come to SO to found where to download this. The download page isn't even on the first result page of Google when you search "sqlpackage.exe download". And Microsoft's own page on sqlpackage doesn't have a download link anywhere. – AllTradesJack Dec 5 '16 at 20:05
19

The following StackOverflow answer gives full details of the various ways you can obtain the latest version of SqlPackage, which works with SQL Server 2005-2014, and where to find it once it's installed:

https://stackoverflow.com/a/23376593/216440

To quote:

Yes, there is a new version supporting SQL Server 2005-2014 available and it installs into a different location than the previous (SQL Server 2012 and lower) version. In fact, you'll have different install locations depending on if you just use SSDT or if you install it as part of SSMS or the standalone installer.

  • SSDT installs the Dac DLLs inside Visual Studio in the latest releases. This is to avoid side by side issues (Visual Studio 2012 vs 2013 vs SSMS) that required all to be updated to use the latest code.

    • If you have updated to the latest SSDT, you'll find SqlPackage.exe and the related DLLs in the VS Install Directory\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120. For VS2013 the VS install directory is C:\Program Files (x86)\Microsoft Visual Studio 12.0.
  • SSMS for SQL Server 2014 and the standalone Dac Framework MSI both install to the system-wide location. This is C:\Program Files (x86)\Microsoft SQL Server\120\Dac\bin.

| improve this answer | |
  • 2
    Your "Dac Framework MSI" link is to the April 2014 version. At the moment, the May 2015 version in @Simon Wang's answer is the latest. – CrazyPyro Dec 14 '15 at 21:45
8

Be warned, this utility is SQL server version specific.

When (if) this is installed it will be found in the 'DAC\bin' subfolder of your SQL server install. So for SQL Server 2012 this will be in:

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

SQL Server 2012 has internal version 11.0 and SQL Server 2014 has internal version 12.0. So for SQL Server 2014 you find SqlPackage here:

C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin
| improve this answer | |
3

I have just realized the tool has a standalone version installer which is called SQL Server® Data-Tier Application Framework, it requires Microsoft SQL Server System CLR Types, and Microsoft SQL Server Transact-SQL ScriptDom.

For latest download link(Version 2014): Microsoft® SQL Server® Data-Tier Application Framework

Other two required components can be download as part of Microsoft® SQL Server® 2014 Feature Pack

After installation the SqlPackage can be found C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin if you are installing x86 version.

This is a way much better and easier way to manage a deploy from server.

| improve this answer | |
2

This seemed to be the smallest "stand alone" installer I could find for the tool in question.

Microsoft® SQL Server® Data-Tier Application Framework (June 30 2016)

https://www.microsoft.com/en-us/download/confirmation.aspx?id=53013

this installed it here:

C:\Program Files\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe

| improve this answer | |
1

If you have Visual Studio with SSDT installed, try

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\130\sqlpackage.exe

or

C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\sqlpackage.exe

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.