Save-ISHIntegrationDBSTSSQLServerConfiguration

NAME Save-ISHIntegrationDBSTSSQLServerConfiguration



SYNOPSIS

Generates SQL Server script that grants necessary permissions.





SYNTAX

Save-ISHIntegrationDBSTSSQLServerConfiguration -FileName <string> [-Type {PS1 | SQL}] [-ISHDeployment

<ISHDeployment>] [<CommonParameters>]





DESCRIPTION

The Save-ISHIntegrationDBSTSSQLServerConfigurationCmdlet generates SQL Server script that grants necessary

permissions into package folder.



Cmdlet will overwrite the file if there is already one with same name.





PARAMETERS

-FileName <string>

Name of the output file.



Required? true

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



-Type <OutputType>

Specifies the output file type. Default value is 'SQL'.



Possible values: PS1, SQL



Required? false

Position? named

Default value SQL

Accept pipeline input? false

Accept wildcard characters? false



-ISHDeployment <ISHDeployment>

Specifies the name or instance of the Content Manager deployment.



Required? false

Position? named

Default value

Accept pipeline input? false

Accept wildcard characters? false



<CommonParameters>

This cmdlet supports the common parameters: Verbose, Debug,

ErrorAction, ErrorVariable, WarningAction, WarningVariable,

OutBuffer, PipelineVariable, and OutVariable. For more information, see

about_CommonParameters (https:/go.microsoft.com/fwlink/?LinkID=113216).



INPUTS



OUTPUTS



---------- EXAMPLE 1 ----------



PS C:\\>Save-ISHIntegrationDBSTSSQLServerConfigurationCmdlet -ISHDeployment $deployment -FileName

GrantPermissions.sql



Generates SQL script that grants necessary permissions. Parameter $deployment is a deployment name or an instance

of the Content Manager deployment retrieved from Get-ISHDeployment cmdlet.

---------- EXAMPLE 2 ----------



PS C:\\>Save-ISHIntegrationDBSTSSQLServerConfigurationCmdlet -ISHDeployment $deployment -FileName

GrantPermissions.ps1 -Type PS1



Generates PS1 script that runs sql command on server and grants necessary permissions. Parameter $deployment is a

deployment name or an instance of the Content Manager deployment retrieved from Get-ISHDeployment cmdlet.



RELATED LINKS