Posted by downwitch on 08/22/07 15:24

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 here
http://www.codeproject.com/useritems/SSMSScriptRunner.asp does not
seem to work.)

Thanks in advance.

• Next in forum: Re: standard and easy way to do schema design
• Prev in forum: Re: A floating point exception occurred in the user process
• Thread view: Run all .sql files (scripts) in project (SQL Server 2005 SP2)

[Reply to this message]