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.exeComplete 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 /r c: sqlpackage.exe
Pipe results to
more if there are too many results
- Graphic User Interface : Microsoft Guide for Data-Tier Application deployment