Test-MgmtSvcDatabase

Verifies database installation.

Syntax

Parameter Set: Default
Test-MgmtSvcDatabase -Schema <String> [-ConnectionString <String> ] [-Database <String> ] [-Password <String> ] [-Server <String> ] [-UserName <String> ] [ <CommonParameters>]

 

Detailed Description

The Test-MgmtSvcDatabase cmdlet verifies installation of a management service database. The cmdlet returns the version of the installed schema.

You can run this cmdlet from any computer in the deployment. However, this cmdlet assumes that the database is on the local computer. If the database is on another computer, you must use the Server, UserName, Password, and Database parameters, or a SQL connection string. If you specify a connection string by using the ConnectionString parameter, that value takes precedence over the Server, UserName, Password, and Database parameters.

Parameters

-ConnectionString<String>

Specifies an SQL connection string.

 

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

-Database<String>

Specifies a database name.

 

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

-Password<String>

Specifies a password.

 

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

-Schema<String>

Specifies a schema. The cmdlet verifies installation of this schema.

 

Aliases	none
Required?	true
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

-Server<String>

Specifies the name of the computer on which the SQL database resides.

 

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

-UserName<String>

Specifies the name of a user account.

 

Aliases	none
Required?	false
Position?	named
Default Value	none
Accept Pipeline Input?	false
Accept Wildcard Characters?	false

 

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters.

Examples

Example 1: Verify a schema installation

This command verifies that the schema named Config is installed.

PS C:\> Test-MgmtSvcDatabase -Schema "Config" -ConnectionString 'Data Source=mysqlserver;Initial Catalog=Microsoft.MgmtSvc.Config;User ID=SysAdmin;Password=Zoom2345'

 

Related topics

Install-MgmtSvcDatabase

Uninstall-MgmtSvcDatabase