execute several scripts at the same time

Last Post 19 Nov 2009 11:22 AM by ogruizr. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
ogruizr
New Member
New Member

--
19 Nov 2009 07:56 AM
Hi all,

I have many scripts (script1.sql, script2.sql, script3.sql....) to execute on the same database. What is the best to do this? I don't want to execute them one by one.
ogruizr
New Member
New Member

--
19 Nov 2009 11:22 AM
I create another script script0, like this:

:r c:\temp\script1.sql
go
:r c:\temp\script2.sql
go
:r c:\temp\script3.sql
go
.
.
.

After that, I executed that script using sqlcmd, like this:

:r c:\temp\script0.sql
go


DO YOU HAVE ANY SUGGESTION?
ogruizr
New Member
New Member

--
19 Nov 2009 11:31 AM
I have many report files (.rdl) to upload them to SQL Server Reporting Service. How can I do that? I don't want to do it one by one.


Acceptable Use Policy
---