How to copy all stored procedure from one server to another.

Posted on 2012-09-21
Medium Priority
Last Modified: 2012-09-22
What is the script to copy all sp frm 1 server to other?
Question by:zachvaldez

Expert Comment

ID: 38423396
In Management Studio, you can copy stored procedures between databases. However, as far as instance to instance, I don't think it is possible.  You would have to right click the stored procedure, script stored procedure as, create to, and either file or new query window.  Then copy that to the new instance and add the stored procedure.

Stored Procedures are more of a database specific thing.  Are you talking about a DMV?
LVL 15

Accepted Solution

tim_cs earned 1120 total points
ID: 38423433
You could right-click on the database -> tasks -> Generate scripts.  Go through the wizard this starts and select Stored Procedures as your Object Type.  This will script out every proc at once which you can then run on the other database.

Author Closing Comment

ID: 38425719
that worked!

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This post looks at MongoDB and MySQL, and covers high-level MongoDB strengths, weaknesses, features, and uses from the perspective of an SQL user.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question