Executing many .sql scripts

[c567591]

Our Database is being created by a batch file, where each script is fired off separately via osql each time.
There are 940 tables plus all the stored procs and triggers and views.

Example:
set @osqlcommand = 'osql -d ASCEND -USA -P'+ @SAPASSWORD + ' -i ' + '"'
set @instatement = @RUNDIR + '\Init\MSSQL\MSSQLInit.sql'
set @instatement = @osqlcommand + @instatement + '"'
select @instatement
exec master..xp_cmdshell @instatement,no_output

This is very slow is there a better way to do this?
how can I do this without going to the shell and running osql each time?

Thanks,
Matt Minnis

 

[ESquared]

You might get a speed increase if you put all the commands together and submit them at once, instead of submitting each command one at a time.

-------------------------------------
A sacrifice is harder when no one knows you've made it.

 

[c567591]

Ok, I can do that.
In general is this the best way to do this?
Is there a better way?

Matt