Move stored procedures from one database to another in SQL Server

Solution 1:

Right click on the SP under the DB and click Script Stored Procedure As > CREATE To > File, it will create an SQL script file, then run that script on the other database.

Solution 2:

Just use the Management Studio to generate a script for the stored procedures, save the script to a file then run it on the other SQL Server.

From memory you right click the database and under All Tasks is Generate Scripts or something like that. This will produce the Transact-SQL to create whatever you select.

Solution 3:

Here is a query (set output to text) to return the stored procedures :

SELECT ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE='PROCEDURE'

Move stored procedures from one database to another in SQL Server

Solution 1:

Solution 2:

Solution 3:

Related

Recent Posts