Jeff Rosenberg

~~I don't think that property does what you're thinking, unfortunately. DacFX / SqlPackage doesn't manage transactions generally, and I don't think that property does anything to set a transaction.~~ ~~I...

@ashishmg-gds would you be able to post the csproj file and generated deployment script?

@ashishmg-gds are you able to share the .csproj file and/or generated deployment script? I could use some more information to troubleshoot this, so please provide whatever you can; otherwise, I'll...

@ashishmg-gds I've been trying to troubleshoot this, but I'm realizing I still need more information. When you say "when i check the dacpac, there is no effect," what do you...

@ashishmg-gds I think this is most likely an Azure Synapse issue, since I was able to validate that this property works correctly for me when doing a local build and...

We do currently support incremental builds. I'm not sure about what controls the specific verbiage coming out of MSBuild, but if no files are changed, the project isn't re-built.

@jmezach looking at the [incremental build docs](https://docs.microsoft.com/en-us/visualstudio/msbuild/how-to-build-incrementally?view=vs-2019) again, I think the difference here is that what's being skipped is our `CoreCompile` target, not the entire build. I'm not sure whether...

I'm not convinced we would want to add an incremental publish step here, since as you said, we'd really need to check the actual database, which I think is too...

To clarify my comments above, my concern about the proposed design is that the last-updated time of the `.dacpac` file isn't necessarily a good way to judge whether a publish...

@jmezach I can give it a try today or tomorrow. If that doesn't work, I don't know how much additional time I can commit to playing around with this, but...