Test-MgmtSvcDatabase

Verifies database installation.

Syntax

Test-MgmtSvcDatabase
    -Schema <String>
    [-ConnectionString <String>]
    [-Server <String>]
    [-Database <String>]
    [-UserName <String>]
    [-Password <String>]
    [<CommonParameters>]

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.

Examples

Example 1: Verify a schema installation

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

This command verifies that the schema named Config is installed.

Required Parameters

-Schema

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

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Optional Parameters

-ConnectionString

Specifies an SQL connection string.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Database

Specifies a database name.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Password

Specifies a password.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-Server

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

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-UserName

Specifies the name of a user account.

Type:String
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False