use sqlpackager to deploy ssdt dacpac's

deploy.cmd

SET PATH=C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin;%PATH%

SET SourceDacpac=%1
SET Server=%2
SET Database=%3
SET DBUser=%4
SET DBPass=%5
SET SqlDeployScript=%6
SET Variables=%7
SET PublishProfile=%8
STE LastAction=

REM If the db doesn't exist then create it
SET LastAction=checking db exists
sqlcmd -U %DBUser% -P %DBPass% -S %Server% -Q "IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = '%Database%') CREATE DATABASE %Database%" -b
if errorlevel 1 goto err


REM Save deployment script
SET LastAction=deploying updates
sqlpackage.exe /action:Publish /sourcefile:%SourceDacpac% /targetservername:%Server% /targetdatabasename:%Database% /targetuser:%DBUser% /targetpassword:%DBPass% /pr:"%PublishProfile%" %Variables% 
if errorlevel 1 goto err

goto success

:err
	echo error occured at %LastAction% - deploy has failed
	exit 1


:success

echo finished