Stored procedures

[Cj1978]

Hi,

I have two databases, one is the live system and the other is probably going to be used for training. I need to copy a large number of procedures from the live DB to the training DB. Almost 100 procedures. What is the quickest method to copy a batch of procedures from one DB to another?

I can't seem to find any way to export them.

Is there a built in tool or a script that will do this for me

thanks

[Cj1978]

Anybody?

This must be fairly common.

[rmiao]

If you use MS SQL, you can script them.

[Cj1978]

If you use MS SQL, you can script them.

Yes it is MS SQL. would you have an example? i can't seem to find anything in the MS documentation. or on the web

[Cj1978]

anyone?

this is getting important

[mikr0s]

ENTERPISE MANAGER ->Tools -> Generate Script -> General Tab (Click on show all button ) : Check stored procedures checkbox -> Formatting Tab: Ensure Generate create and drop objects checkboxes are checked ->Options Tab:choose if there will be one file for all procs or several files per proc, better choose one file -> Press OK button -> save to a file on your pc -> after completion of the process open the file with a txt editor -> copy the content of the file -> paste it in Query Analyzer -> Execute it on the database


--HTH--

[Cj1978]

Cool!

thanks for that.

Cj