SQL Server Performance Forum – Threads Archive
Exporting Stored ProcedureI 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
"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
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. —
Microsoft SQL Server MVP
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)