How to deploy dacpac using SQLPackage.exe

ByAnkush Jain| Last Updated On Monday, Jun 18, 2018

SQL Server

Disclaimer: I am a consultant at Amazon Web Services, and this is my personal blog. The opinions expressed here are solely mine and do not reflect the views of Amazon Web Services (AWS). Any statements made should not be considered official endorsements or statements by AWS.

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.

   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:

   

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.