All geek questions in one place

SQL Server: copying stored procedures

Is there an easy way to copy all stored procedures from one database to another? I have SQL Management Studio installed.

+3
source share
2 answers

In the management of SQL 2005 and 2008: right-click on the database, select tasks → generate scripts. You should be able to follow the directions in the wizard from there.

In Sql 2000, you can simply select the procedures you want to copy, ctrl + c, to copy them, and then paste them into a new query window for another database and start it.

+5
source

script SQL Management Studio script ( - , Windows , ). , 1 . , , .

Red Gate Software SQL Compare http://www.red-gate.com/products/SQL_Compare/index.htm , .

+1

Source: https://habr.com/ru/post/1722400/

More articles:


All Articles