How to create ALTER scripts instead of CREATE scripts using SMO (server control object)

Question

I am using Microsoft.SqlServer.Management.Smo classes for script from SQL scripts for stored procedures, tables, views, etc. I do this in order to put them in the original management.

Instead of CREATE scripts for stored procedures, how can I get ALTER scripts for them? Is there a / option parameter in ScriptingOptions properties ?

Answer 1

There seems to be no settings for ALTER scripts. A property with ScriptingOptions.ScriptDrops as true creates drop statements. The disadvantage of this is that permissions had to be reassigned.

The completion of this question.

Answer 2

Take a look at DBSourceTools .

This is a GUI tool for scripting all objects in an SQL database to disk, in particular for managing databases from source code. Back-end uses SMO.

Answer 3

• SMO #

• .

  foreach (string line in script)
              {
                  string l = line.Replace("CREATE FUNCTION", "ALTER FUNCTION");
              }
  

• .:).

Answer 4

. toSP - SP. "TO" , Create(), Alter() StoredProcedure spT

If toSP = "" Then  ' Empty
    spT.Create()
Else
    spT.Alter()
End If

Answer 5

StoredProcedure , ALTER.

https://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.storedprocedure.scriptheader(v=sql.120).aspx

Using

var sprocHeader = sproc.ScriptHeader(forAlter: true);
var sprocBody = sproc.TextBody;