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.
Parameters
-ConnectionString
Specifies an SQL connection string.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Database
Specifies a database name.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Password
Specifies a password.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Schema
Specifies a schema. The cmdlet verifies installation of this schema.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| 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 |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-UserName
Specifies the name of a user account.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |