Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

ScriptingOptions.ToFileOnly Property

Gets or sets the Boolean property value that specifies whether to output to file only or to also generate string output.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public bool ToFileOnly { get; set; }

Property Value

Type: System.Boolean
A Boolean value that specifies whether to output to file only or to also generate string output.If True, the generated script is output to file only. Otherwise, False (default).

Specify this option whenever string output is not required, because scripting dependencies can potentially yield a very large string.

The following code example specifies that output will be written to a file only. No string output will be generated.

Visual Basic

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

PowerShell

$scOps = New-Object Microsoft.SqlServer.Management.Smo.ScriptingOptions
$scOps.ToFileOnly = $TRUE
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.