为多个数据库复制SP [英] replicating a SP for multiple databases

问题描述

我有大约400 Sp''s(存储过程)用于一个数据库，我需要复制大约12个DB's.
我该如何快速执行此操作.现在我正在逐个执行每个DB的每个SP，这非常耗时.
否则我必须执行400 * 12次.

阿布舍克
在此先感谢.

Hi,

I have around 400 Sp''s(Stored Procedure) for a DB which i need to replicate for around 12 DB''s.
how can i do it in quick time.right now i am executing each SP for each DB one by one which is very time consuming.
otherwise i have to execute 400*12 times.

Abhishek
Thanks in advance.

推荐答案

一种方法是使用导出选项.您可以将所有过程导出到其他数据库，Excel甚至文本文件中.

One way is using the export option. You can export all the procedures to a different database, excel or even a text file.

这篇关于为多个数据库复制SP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！