Executing batch SQL scripts with "GO" statements

[djjd47130]

We have a large software package which we execute MSSQL database updates via OSQL (command line). This is because we have not yet found a component or anything which can recognize the 'GO' statement. 'GO' makes sure all previous commands have finished executing before it continues to the next batch of commands.

I'm thinking the best thing to do is to break down these script files wherever it has 'GO' and execute batch by batch. It's sloppy the way we do it now, because the OSQL command saves an output file, which we have to manually read and try to determine if there are any errors.

Someone please advise if there is an easier way to execute large SQL scripts to update a large database with the 'GO' statement at least 100 times in the script.


JD Solutions

 

[djjd47130]

Actually, the best understanding equivalent to the GO statement is like in Delphi the 'Application.ProcessMessages' command, which makes sure all windows messages and commands are finished before the code continues. Same concept.

JD Solutions

 

[whosrdaddy]

proceed as you said, execute batch by batch.

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!