Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Example DACPAC Publish Profile
<?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>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment