Get-SCSQLScriptCommand

Gets a SQL Server script for an application deployment.

Description

The Get-SCSQLScriptCommand cmdlet gets a SQL Server script for an application deployment.

For more information about Get-SCSQLScriptCommand, type: "Get-Help Get-SCSQLScriptCommand -online".

Parameters

ApplicationDeployment

Required? true
Accept Pipeline Input? true (ByValue)
Position? named 
Specifies an application deployment object.

VMMServer

Required? false
Accept Pipeline Input? true (ByValue)
Position? named 
Specifies a VMM server object.

Examples

1: Get a specified SQL Server script command for an application deployment. 
PS C:\> $AppProfile = Get-SCApplicationProfile -Name "SvcWebAppProfile01"
PS C:\> $AppDeployment = Get-SCApplicationDeployment -ApplicationProfile $AppProfile -Name "SQLDataTierApp01"
PS C:\> Get-SCSQLScriptCommand -ApplicationDeployment $AppDeployment | where {$_.DeploymentOrder -eq "1" -and $_.SQLScriptType -eq "PreInstall"}

The first command gets the application profile object named SvcWebAppProfile01 and stores the object in the $AppProfile variable.

The second command gets the application deployment object named SQLDataTierApp01 for the application profile stored in $AppProfile, and then stores the object in the $AppDeployment variable.

The last command gets the first PreInstall SQL Server script (deployment order 1, SQL script type PreInstall) associated with the application deployment stored in $AppDeployment.

See Also