MSBUILD Executing only Changed SQL Scripts

Question

I need to construct an MSBUILD script executes .SQL Scripts which have changed since last build.

I initially thought that I could copy all scripts from one folder to another using the <Copy> task and using the CopiedFiles <Output> for the copy task. However the copy task returns All files that it Attempted to copy, not actual copied files.

I am able to get MSBUILD to execute SQL Scripts via MSBUILD.ExtensionPack but Im scratching my head on this one

it seems some of my text was interpreted as tags, Second paragraph should read: I initially thought that I could copy all scripts from one folder to another using the COPY task and using the CopiedFiles OUTPUT for the copy task. However the copy task returns All files that it Attempted to copy, not actual copied files. — imbz
– imbz, Commented Feb 6, 2010 at 1:48

Sayed Ibrahim Hashimi · Accepted Answer · 2010-02-07 21:14:55Z

3

You can do this with a concept known as incremental building. The idea is that you would create a target and then specify the inputs and outputs, which would be files. MSBuild will compare the timestamps of the input files to the output files. If all outputs were created after all outputs then the target is skipped. If all inputs are newer then all the target will be executed for all files. If only a portion are out of date, then only those will be passed to the target. For more info on this see the section Using Incremental Builds in my article Best Practices For Creating Reliable Builds, Part 2.

Also for more resources on MSBuild I have compiled a list at http://sedotech.com/Resources#MSBuild

answered Feb 7, 2010 at 21:14

Sayed Ibrahim Hashimi

44.5k18 gold badges150 silver badges180 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jeremy Stein · Accepted Answer · 2010-09-02 15:17:30Z

3

<Project xmlns="http://schemas.microsoft.com/developer/msbuild/2003" DefaultTargets="RunScripts">

  <Import Project="$(MSBuildExtensionsPath)\ExtensionPack\MSBuild.ExtensionPack.tasks"/>

  <PropertyGroup>
    <ConnStr>Server=Example;Database=Example;Trusted_Connection=True</ConnStr>
    <BuildFolder>Build\</BuildFolder>
  </PropertyGroup>

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

  <Target Name="RunScripts"
          Inputs="@(Scripts)"
          Outputs="@(Scripts->'$(BuildFolder)%(Filename)%(Extension)')">
    <SqlExecute TaskAction="ExecuteScalar"
                Files="@(Scripts)"
                ConnectionString="$(ConnStr)"/>
    <Copy SourceFiles="@(Scripts)"
          DestinationFiles="@(Scripts->'$(BuildFolder)%(Filename)%(Extension)')"/>
  </Target>
</Project>

answered Sep 2, 2010 at 15:17

Jeremy Stein

19.8k18 gold badges71 silver badges84 bronze badges

1 Comment

Raffaeu Over a year ago

This is exatcly how to solve the issue also with Data Dude. It would be nice if MS will provide this task "out of the box".

Filburt · Accepted Answer · 2010-02-06 12:37:37Z

0

Could it be that you copying into an empty destination?

SkipUnchangedFiles

If true, skips the copying of files that are unchanged 
between the source and destination. The Copy task considers 
files to be unchanged if they have the same size and the 
same last modified time.

In your case i suspect that all files are considered changed since they don't exist at the destination.

answered Feb 6, 2010 at 12:37

Filburt

18.1k14 gold badges106 silver badges167 bronze badges

2 Comments

imbz Over a year ago

No, The copy task reports all attempted copied files not just actually copied files. This is an known issue I've seen while searching the interwebs.

Filburt Over a year ago

@imbz - Dang it! You're right - i never heard about this stupid bug before.

Collectives™ on Stack Overflow

MSBUILD Executing only Changed SQL Scripts

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related