复制存储过程 [英] Copy Stored Procedures

问题描述

我正在使用驻留在1台服务器上的数据库.现在，我要在系统上使用该数据库的完全相同的副本.我尝试导出数据，但这只能得到表格和结果.我无法获取数据库中的存储过程.除了备份，还有谁能帮助我吗?

I am using a database that resides on 1 server. Now I want exactly the same copy of that database on my system. I tried export data but that only gets the tables and vies . I am not able to get the stored procedures in the database. Can anyone help me on this other than backup ?

推荐答案

查看此内容

Check this out


http://blog.sqlauthority.com/2009/07/29/sql-server-2008-copy-database-with-data-generate-t-sql-for-inserting-data-from-one-table-to-another-table/[^]

您需要首先访问数据库，这是您要复制存储过程，然后右键单击它，然后任务然后生成脚本.选择数据库后，它会向您显示一些选择，例如表，视图，存储过程等.选择存储过程，它将生成一个script.sql文件.
实用参考:-

you need to access your database first which is you want to copy the store procedures and then right click on it and then tasks then generate scripts. After you choose your database it shows you some selections like tables, views, stored procedures ...etc. Choose stored procedures and it will generate a script.sql file.
For practical reference :- Copy stored procedures to different database[^]

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