On Aug 22, 11:24 am, downwitch <downwi...@gmail.com> wrote:
> Hello,
>
> I've run as many keyword combinations searching for this as I can
> think of, but cannot find a simple answer.
>
> The situation: I have a database that is mid-conversion/redevelopment.
> I frequently rebuild my dev copy from the production version, which
> requires a bunch of DDL script, and then adding in all the stored
> procedures necessary to the new version only. Each sp may have changed
> since the last time it was run, so I can't exactly keep them all
> concatenated in a single file or anything like that.
>
> So the only way I can see to execute each and every one of these saved
> script files is to open it up in SSMS and hit F5 for execute. This is
> a silly waste of time, it seems to me, and hardly foolproof. Is there
> not some simple way to run every script in a project? What purpose
> does a project serve, otherwise?
>
> (Worth mentioning that the tool I found herehttp://www.codeproject.com/useritems/SSMSScriptRunner.aspdoes not
> seem to work.)
>
> Thanks in advance.

Hello downwitch,

xSQL Software has just released a free utility, xSQL Script Executor,
that allows you to run multiple T-SQL scripts at once - you can choose
individual scripts or whole folders and run them all. You can choose
to wrap all scripts in one big transaction or not, you can call it
from the command line etc. Check it out at:
http://www.xsqlsoftware.com/Product/...orDetails.aspx

Thanks,
JC
xSQL Software
http://www.xsqlsoftware.com