Add support for incremental builds about msbuild.sdk.sqlproj HOT 6 OPEN

@ChristopherHaws Thanks for reporting this. We've had a few similar issues, such as #63. I remember looking at the up-to-date document back then, but couldn't figure out why it wouldn't work at the time as we didn't have too much to go on.

This output helps, although it is interesting to see such a huge time difference between those two files. Can you consistently reproduce this? If so, it would be really helpful to have a binary log of both the initial build and the incremental build.

from msbuild.sdk.sqlproj.

I was able to achieve this by adding the following to the csproj file:

<ItemGroup>
        <UpToDateCheckInput Include="**/*.sql" />
</ItemGroup>

from msbuild.sdk.sqlproj.

@ChristopherHaws Did you try @zlatanov suggestion above?

from msbuild.sdk.sqlproj.

Just to add info that might or might not help. I do something similar to what @zlatanov suggests but referring to the files in the original project with the UpToDateCheckInput like this:

<Project Sdk="MSBuild.Sdk.SqlProj/2.5.0">
  <PropertyGroup>
      <TargetFramework>netstandard2.0</TargetFramework>
      <SqlServerVersion>Sql140</SqlServerVersion>
      <AppendTargetFrameworkToOutputPath>false</AppendTargetFrameworkToOutputPath>
      <DeployOnPublish>false</DeployOnPublish>
      <OutputPath>bin</OutputPath>
  </PropertyGroup>

  <ItemGroup>
    <UpToDateCheckInput Include="../MyAppDatabase/**/*.sql" />
  </ItemGroup>

  <ItemGroup>
    <Content Include="../MyAppDatabase/**/*.sql" />
    <Content Remove="../MyAppDatabase/bin/**" />
    <Content Remove="../MyAppDatabase/obj/**" />
    <Content Remove="../MyAppDatabase/Deployment/**" />
    <Content Remove="../MyAppDatabase/Security/Users/**" />
  </ItemGroup>
</Project>

I've fiddled a bit with different options but got this to work. On the other end referring to the MSBuild.Sdk.SqlProj/2.5.0-project from other projects without explicitly linking the dacpac seems to also require an UpToDateCheck on the referring projects like this:

<ItemGroup>
    <UpToDateCheckBuilt Include="$(OutDir)MyAppDatabase.Build.dacpac" Original="../MyAppDatabase.Build/bin/MyAppDatabase.Build.dacpac" />
</ItemGroup>

from msbuild.sdk.sqlproj.

@ChristopherHaws any news?

from msbuild.sdk.sqlproj.

@ErikEJ Sorry, I have been super busy with other things. I can try to change sometime this week and I will get back to you. Sorry about the long response! ^_^

from msbuild.sdk.sqlproj.