Example DACPAC Publish Profile

DbPublish.xml

<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
  <PropertyGroup>
    <TargetDatabaseName>YourDatabase</TargetDatabaseName>
    <DeployScriptFileName>YourFileName.sql</DeployScriptFileName>
    <CreateNewDatabase>False</CreateNewDatabase>
    <IncludeCompositeObjects>True</IncludeCompositeObjects>
    <GenerateSmartDefaults>True</GenerateSmartDefaults>
    <BlockOnPossibleDataLoss>True</BlockOnPossibleDataLoss>
    <DropObjectsNotInSource>False</DropObjectsNotInSource>
    <DoNotDropDatabaseScopedCredentials>False</DoNotDropDatabaseScopedCredentials>
    <DoNotDropLogins>False</DoNotDropLogins>
    <DropStatisticsNotInSource>False</DropStatisticsNotInSource>
    <ScriptDatabaseOptions>True</ScriptDatabaseOptions>
    <ProfileVersionNumber>1</ProfileVersionNumber>
    <DatabaseEdition>Basic</DatabaseEdition>
    <DatabaseServiceObjective>Basic</DatabaseServiceObjective>
    <DatabaseMaximumSize>2</DatabaseMaximumSize>
    <DropIndexesNotInSource>False</DropIndexesNotInSource>
    <DropExtendedPropertiesNotInSource>True</DropExtendedPropertiesNotInSource>
  </PropertyGroup>
</Project>