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.
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.
Go to SQLPackage.exe file location from command line. See below picture.
Now run below command to deploy the dacpac from SQLPackage.exe.
SqlPackage.exe /Action:Publish /SourceFile:"<DACPAC File Path>" /TargetDatabaseName: <DatabaseName> /TargetServerName:"<Server Name>"
SqlPackage.exe /Action:Publish /SourceFile:"C:\Users\ankushjain\Documents\SQL Server Management Studio\DAC Packages\dbHMS.dacpac" /TargetDatabaseName:HospitalManagementSystem /TargetServerName:"localhost"
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.