使用C#创建存储过程的脚本 [英] Create Script of Stored Procedure using C#

问题描述

如何从C#创建存储过程的脚本?

我的要求是使用c#从sql server数据库中备份存储过程和函数?

在此先谢谢您.

How to Create a script of Stored Procedures from C# ?

My requirement is to take backup of stored procedures & functions from sql server database using c# ?

Thanks in Advance.

推荐答案

尝试查找此工具.
ScriptDB
[^ ]

它使用SQL管理对象(SMO)编写数据库对象的脚本.

try to look for this tool.
ScriptDB
[^]

It uses SQL Management Objects (SMO) to script the database objects.

请参阅答案关于StackOverflow的相同问题: http://stackoverflow.com/questions/169330/simple-way- to-programmatically-get-all-stored-procedures [ ^ ].

问候，

曼弗雷德(Manfred)

See Pavel Chuchuva''s answer on the same question that was asked on StackOverflow: http://stackoverflow.com/questions/169330/simple-way-to-programmatically-get-all-stored-procedures[^].

Regards,

Manfred

这篇关于使用C#创建存储过程的脚本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！