SQL Server Performance Forum – Threads Archive

Copying stored procedures

I’d like to know what would be the best way of moving more than 300 stored procedures from one database to another database. The databases are in two different servers. Try to avoid using copy and paste since it would take long time to move 300+ stored procedures. Any input will be appreciated. Thanks.

One way is to script all sp using EM and recreate in new server using QA.
Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

You can use Enterprise Manager to copy the objects. Right-click on the source DB, All Tasks, Export Data. Follow the wizard and uncheck "Copy all objects", click on Options.. and choose the stored procedures.
Keith Payne
Technical Marketing Solutions
www.tms-us.com

I would also script them out and apply that script on the other server, but I think there is also some DTS task with which you can transfer database objects. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstÃ¼tze PASS Deutschland e.V. http://www.sqlpass.de)

Scripting them out is only best method where you can keep the source code and make necessary changes whenever required to apply, also you can use version control if in doubt about anyone changes. 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.

]]>