Script

New-DbaReplCreationScriptOptions

Jess Pomfret (@jpomfret), jesspomfret.com

New-DbaReplCreationScriptOptions View Source Jess Pomfret (@jpomfret), jesspomfret.com Windows, Linux, macOS Synopsis Creates replication article creation script options for controlling which database objects are replicated Description Creates a Microsoft.SqlServer.Replication.CreationScriptOptions object that controls which database objects and properties are included when replicating tables through SQL Server replication. This determines what gets scripted at the subscriber when articles are added to publications - things like indexes, constraints, triggers, and identity columns. By default, includes the same options that SQL Server Management Studio uses when adding articles: primary objects, custom procedures, identity properties, timestamps, clustered indexes, primary keys, collation, unique keys, and constraint replication settings.

New-DbaScriptingOption

Chrissy LeMaire (@cl), netnerds.net

New-DbaScriptingOption View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Creates a customizable SMO ScriptingOptions object for controlling T-SQL script generation Description Creates a Microsoft.SqlServer.Management.Smo.ScriptingOptions object that controls how SQL Server objects get scripted into T-SQL CREATE statements. This object lets you customize what gets included when using Export-DbaScript and other dbatools scripting commands - things like whether to include indexes, triggers, permissions, dependencies, or batch separators. Perfect for creating deployment scripts where you need specific control over what gets scripted and how it’s formatted.