Download and install sqlpackage

sqlpackage runs on Windows, macOS, and Linux.

Download and install the latest .NET Framework release and macOS and Linux previews:

Platform Download Release date Version Build
Windows MSI Installer September 18, 2020 18.6 15.0.4897.1
macOS .NET Core .zip file September 18, 2020 18.6 15.0.4897.1
Linux .NET Core .zip file September 18, 2020 18.6 15.0.4897.1
Windows .NET Core .zip file September 18, 2020 18.6 15.0.4897.1

For details about the latest release, see the release notes. To download additional languages, see the Available Languages section.

DacFx

DacServices (Microsoft.SqlServer.Dac) is a related mechanism for integrating database deployment into your application pipeline. The DacServices API is available in a package through nuget, Microsoft.SqlServer.DACFx. The current DacFx version is 150.4897.1.

Installing the nuget package via the .NET CLI is accomplished with this command:

> dotnet add package Microsoft.SqlServer.DACFx

Note

Additional nuget packages were published under the DacFx name, "Microsoft.SqlServer.DacFx.x64" and "Microsoft.SqlServer.DacFx.x86". Support for both platforms is covered under the "Microsoft.SqlServer.DACFx" package. New references should be made to this package, not the x64 or x86 variants.

Get sqlpackage for Windows

This release of sqlpackage includes a standard Windows installer experience, and a .zip:

  1. Download and run the DacFramework.msi installer for Windows.
  2. Open a new Command Prompt window, and run sqlpackage.exe
    • sqlpackage is installed to the C:\Program Files\Microsoft SQL Server\150\DAC\bin folder

Get sqlpackage .NET Core for Windows

  1. Download sqlpackage for Windows.

  2. To extract the file by right clicking on the file in Windows Explorer, and selecting 'Extract All...', and select the target directory.

  3. Open a new Terminal window and cd to the location where sqlpackage was extracted:

    > sqlpackage
    

Get sqlpackage .NET Core for macOS

  1. Download sqlpackage for macOS.

  2. To extract the file and launch sqlpackage, open a new Terminal window and type the following commands:

    $ mkdir sqlpackage
    $ unzip ~/Downloads/sqlpackage-osx-<version string>.zip -d ~/sqlpackage 
    $ echo 'export PATH="$PATH:~/sqlpackage"' >> ~/.bash_profile
    $ source ~/.bash_profile
    $ sqlpackage
    

    Note

    Security settings may require modification to run sqlpackage on macOS. Use the following commands to interact with Gatekeeper from the command line.

    Before executing sqlpackage:

    $ sudo spctl --master-disable
    

    After executing sqlpackage:

    $ sudo spctl --master-enable
    

Get sqlpackage .NET Core for Linux

  1. Download sqlpackage for Linux by using one of the installers or the tar.gz archive:

  2. To extract the file and launch sqlpackage, open a new Terminal window and type the following commands:

    $ cd ~
    $ mkdir sqlpackage
    $ unzip ~/Downloads/sqlpackage-linux-<version string>.zip -d ~/sqlpackage 
    $ echo "export PATH=\"\$PATH:$HOME/sqlpackage\"" >> ~/.bashrc
    $ chmod a+x ~/sqlpackage/sqlpackage
    $ source ~/.bashrc
    $ sqlpackage
    

    Note

    On Debian, Redhat, and Ubuntu, you may have missing dependencies. Use the following commands to install these dependencies depending on your version of Linux:

    Debian:

    $ sudo apt-get install libunwind8
    

    Redhat:

    $ yum install libunwind
    $ yum install libicu
    

    Ubuntu:

    $ sudo apt-get install libunwind8
    
    # install the libicu library based on the Ubuntu version
    $ sudo apt-get install libicu52      # for 14.x
    $ sudo apt-get install libicu55      # for 16.x
    $ sudo apt-get install libicu57      # for 17.x
    $ sudo apt-get install libicu60      # for 18.x
    

Uninstall sqlpackage

If you installed sqlpackage using the Windows installer, then uninstall the same way you remove any Windows application.

If you installed sqlpackage with a .zip or other archive, then delete the files.

Supported Operating Systems

sqlpackage runs on Windows, macOS, and Linux and is built using .NET Core 3.1. The .NET Core 3.1 OS requirements apply to sqlpackage.

Windows (x64)

  • Windows 10 (1607+)
  • Windows 8.1
  • Windows 7 SP1
  • Windows Server Core
  • Windows Server 2012 R2
  • Windows Server 2016
  • Windows Server 2019

macOS

  • macOS 10.15 "Catalina"
  • macOS 10.14 "Mojave"
  • macOS 10.13 "High Sierra"

Linux (x64)

  • Red Hat Enterprise Linux 7+
  • SUSE Linux Enterprise Server v12 SP2+
  • Ubuntu 16.04+

Available Languages

This release of sqlpackage can be installed in the following languages:

sqlpackage Windows:
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

sqlpackage .NET Core Windows:
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

sqlpackage .NET Core macOS:
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

sqlpackage .NET Core Linux:
Chinese (Simplified) | Chinese (Traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

Next Steps

Microsoft Privacy Statement