Run *.dacpac file command line
Dacpac is a binary produced by a source controlled MS SQL database that will allow you to script and source control your database schemas.
Automates the Data Definition Language script creation and deployment through the use of either. WARNING the dacpac utilities are SQL Server version dependent so SQL Server 201X needs to be available for the dacpac to run properly.
- Command line interface - You will need to download the Sql Server Data Tools to install this tool:
sqlpackage.exe
Complete listing of parameters and options
SqlPackage.exe /Action:Publish /SourceFile:<PATH TO DACPAC FILE>.dacpac /TargetDatabaseName:<DATABASE THAT DACPAC WILL DEPLOY TO> /TargetServerName:localhost /p:RegisterDataTierApplication=True
To find where your sqlpackage.exe is installed I would use the where
command
where /r c: sqlpackage.exe
Pipe results to more
if there are too many results
- Graphic User Interface : Microsoft Guide for Data-Tier Application deployment