< Back

Ping-SsasDatabase

Mon Jan 13, 2020 6:59 pm

NAME Ping-SsasDatabase



SYNOPSIS

Checks that the database exists on the specified SQL Server SSAS instance





SYNTAX

Ping-SsasDatabase [-Server] <String> [-CubeDatabase] <String> [<CommonParameters>]





DESCRIPTION

Checks that the database exists on the specified SQL Server SSAS instance





PARAMETERS

-Server <String>

Name of the SSAS server, including instance and port if required.



Required? true

Position? 1

Default value

Accept pipeline input? false

Accept wildcard characters? false



-CubeDatabase <String>

The name of the cube database to be deployed.



Required? true

Position? 2

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

System.Boolean





NOTES





Written by (c) Dr. John Tunnicliffe, 2019 https://github.com/DrJohnT/DeployCube

This PowerShell script is released under the MIT license http://www.opensource.org/licenses/MIT



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



PS C:\\>Ping-SsasDatabase -Server build02 -CubeDatabase 'MyTabularCube'



Returns true of the SSAS instance on build02 has a cube called 'MyTabularCube'











RELATED LINKS

https://github.com/DrJohnT/DeployCube