如何将存储过程从一个数据库复制到另一个数据库 [英] how to copy store procedures from one database to another

问题描述

大家好，
我正在尝试将所有存储过程从一个数据库复制到SQL Server-2008中的另一个数据库. 为此，我正在尝试通过google进行以下操作:

hi all,
i am trying to copy the all store procedures from one database to another database in SQL server-2008.
forthat i am trying like this by google :

open sql > right click on database (you can say source you want to make a copy )
>then select task > Generate script > click on next next

但是，此处未将选项显示为-选择任务.因此，如何将所有存储过程从一个数据库复制到另一个数据库.请任何人帮助我.
在此先感谢

but ,here not showing option as -- select task. so how can i copy the all store procedures from one data base to another. please anybody help to me.
thanks in advance

推荐答案

希望此链接将为您提供帮助:

http://www.dreamincode.net/code/snippet2028.htm [

Hope This Link will Help you:

http://www.dreamincode.net/code/snippet2028.htm[^]

此链接将帮助您:

This link will defiantly help you:

http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

这篇关于如何将存储过程从一个数据库复制到另一个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！