Custom MSBuild task for running sql scripts

home
other
view story

7 Kicks

Kick It

Drop Kick

Kicked

Custom MSBuild task for running sql scripts(devauthority.com)

submitted by gavinjoyce(25.7k) 5 years, 8 months ago

joeyDotNet has created a custom MSBuild task to run any number of sql scripts in a directory

1 comment |category: Other |Views: 244
Tweet

tags: SQL MSBuild another

Everyones tags:

Your Tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

jhol3990(495) -

ashithmr(90) -

donthop(0) -

GreekTheNick(0)

More who kicked this story...

Comments:

posted by picklesinmyears(0) 5 years, 5 months ago 0

All you need to do is this:

<ItemGroup>
<StoredProcScripts Include="$(RelativeSPDir)/*.sql" />
</ItemGroup>

<Target>
<Exec Command="isql -E -n -b -d DBName -i %(StoredProcScripts.Identity)" Condition="'%(StoredProcScripts.Identity)' != ''"/>
</Target>

Most Active Users

What's this?