开发者

Generate scripts SQL Server 2008

I would like to generate scripts of about 100 Stored Procedures. When I generate script, all the files contains 'CREATE PROCEDURE' statement. How should I get scripts with 'ALTER PROCEDURE' statement?开发者_高级运维


  • Find/replace in an editor
  • Script with a DROP first
  • Use a 3rd party to generate a differential script instead


If you generate all the scripts to a new query window you could press Ctrl-Shift-H to get the find and replace in files dialog up and do a finf and replace on 'CREATE PROCEDURE' to 'ALTER PROCEDURE'?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜