SQL Server Performance Forum – Threads Archive

Exporting Stored Procedure

I have around 60 sp for a db on my local server.I want to export them to remote production server.I am wondering how can I export Stored proceedures??

you can do it with dts / import export wizard tooo regards hsGoswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemant Goswami

or you can script the SPs and run them in the remote production server

OR, you can create script of SP’s.. right click on database, all task..’Generate SQL script’.. here select only sp in ‘object to script’. Deepak Kumar –An eye for an eye and everyone shall be blind

oops! Deepak and I posted same answer in few seconds

I would go with SCRIPTING option as it gives you a chance to recreate the SPs with no issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Also, with scripting you have done the first step to treat your SQL Server code like any other sourcecode. You have something you can stored in sourcesafe. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

]]>