且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何使用c#在Sql server中生成脚本(包含数据和模式)

更新时间:2023-02-07 14:06:44

单击Generate Scripts并选择Advanced Setting并选择 DATA OF OF TO TO SCRIPT SELECT方案和数据 ...
click Generate Scripts and Choose Advanced Setting And Choose TYPE OF DATA TO SCRIPT And SELECT Schemes And DATA ...


如果你有可能,使用SMO(Sql Management Objects) [ ^ ]可能是最简单的方法。特别是使用 Scripter class [ ^ ]。



例如,看看 http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated [ ^ ]
If you just have the possibility, using SMO (Sql Management Objects)[^] is probably the easiest way. Especially using Scripter class[^].

For example have a look at http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated[^]