How to deploy dacpac using SQLPackage.exe

To deploy the database from dacpac, we will be using SQLPackage.exe.

SQLPackage.exe is a command line utility that allow us to perform many database related operations from the command line.

You can follow below steps to deploy a database to SQL Server from the .dacpac file.

  1. First, you have to go to the location where SQLPackage.exe is placed on your system. On my system, it is placed on below location:

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

    You can follow this StackOverflow answer to find out the location of this file on your system.

  2. Go to SQLPackage.exe file location from command line. See below picture. enter image description here

    Now run below command to deploy the dacpac from SQLPackage.exe.

    Generalised Command:

    SqlPackage.exe /Action:Publish /SourceFile:"<DACPAC File Path>" /TargetDatabaseName: <DatabaseName> /TargetServerName:"<Server Name>"

    Actual Command:

    SqlPackage.exe /Action:Publish /SourceFile:"C:\Users\ankushjain\Documents\SQL Server Management Studio\DAC Packages\dbHMS.dacpac" /TargetDatabaseName:HospitalManagementSystem /TargetServerName:"localhost"

    Actual Screenshot:

    enter image description here

This is how you can deploy dacpac from SQLPackage.exe.

In above example, we tried to deploy the dacpac on the localhost. But if you want to deploy it on the remote server then you can use /TargetConnectionString: parameter while executing SQLPackage.exe.

You can find more detail about more detail about SQLPackage.exe and it's parameters from its official page.

Buy Me A Coffee