This topic has not yet been rated - Rate this topic

ScriptingOptions.AppendToFile Property

Gets or sets a Boolean property value that specifies whether the script is appended to the end of the output file or overwrites it.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

C++

JScript

Copy


public bool AppendToFile { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether the generated script is appended to the end of the output file or overwrites it.If True, the generated script is appended to the end of the output file.If False (default), the generated script overwrites the existing contents of the output file.

Examples

The following code example specifies that the script overwrites or is appended to the end of the output file.

Visual Basic

Copy

Dim scOps As New ScriptingOptions()
scOps.AppendToFile = true

PowerShell

Copy

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.AppendToFile = $TRUE

Reference

ScriptingOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Scripting

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ