Search code examples
sql-servervisual-studiopublishdacpac

Include PostDeployment sql script in publish only in debug mode

I have .dacpac project with Script.PostDeployment.sql:

:r .\SiteType.sql
:r .\Enums.sql
:r .\DebugData.sql

I want to include DebugData.sql conditionaly, only when i publish with DEBUG configuration profile selected in visual studio, so i will not have this data included when publish for production.

Is there any way to achieve it?

Solution

  • You can edit the .sqlproj file used by MSBuild that you use to create your dacpacs.

    You can configure the .sqlproj so that certain scripts are included or not depending on what build configuration you are using.

    Steps:

    1. Create a project and add a PostDeployment script

    2. Edit the .sqlproj file

    3. Change the ItemGroup containing the PostDeploy script:

      <ItemGroup Condition=" '$(Configuration)' == 'Debug' "> <PostDeploy Include="PostDeployment.sql" /> </ItemGroup>

    4. Build in Debug configuration. Extract the dacpac and you will find PostDeployment.sql

    5. Build in Release configuration. Extract the dacpac and you will not find PostDeployment.sql.