If you are in SQL 2000 there is a debugger which will allow you to step through a script. Also in Query anallyzer, you could highlight the part of the script you want to run and then execute. If you have text highlighted that is the only part that will run.
Or of course you could save the scripts as indivdual objects and then run them one at a time.
Or you could just detach the database and copy it to the development server, then attach it back to production and development. This way, you also get the data, which running the scripts won't do and it's fast.
If you are just moving to a development/production environment, I suggest you get a tool called SQL Compare. It will allow you to compare the two databases and create scripts to move the chnaged or new objects. It is a major help to me when I am moving new stuff to production. Its not foolproof, you still have to be careful what order you move things (I usually move tables first, then views, then stored procedures)and you may have to check permissions after you move things, but it really helps keep you from forgetting to move things.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.