Export (0) Print
Expand All
Expand Minimize

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:
property bool ToFileOnly {
	bool get ();
	void set (bool value);
}

Property Value

Type: 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

Community Additions

ADD
Show:
© 2014 Microsoft