Test-NAVTenantDatabaseSchema

Checks for any errors in the tenant database schema.

Syntax

Test-NAVTenantDatabaseSchema
    [-ServerInstance] <String>
    [-Tenant <TenantId>]
    [-Force]
    [-ProgressAction <ActionPreference>]
    [<CommonParameters>]

Description

You use the Test-NAVTenantDatabaseSchema cmdlet to compare the tables in the tenant database to the expected metadata of the tables known to the server. This will help to proactively identify errors in the schema.

The tenant database must first be synchronized before its schema can be analyzed.

Examples

EXAMPLE 1

Test-NAVTenantDatabaseSchema -ServerInstance BC -Tenant Tenant1

This example tests the schema of the database belonging to Tenant1, that is mounted against the specified Business Central Server instance.

Parameters

-Force

Forces the command to run without asking for user confirmation.

Type:SwitchParameter
Position:Named
Default value:False
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ProgressAction

A common PowerShell parameter that determines how PowerShell responds to progress updates generated by a script, cmdlet, or provider. Learn more.

Type:ActionPreference
Aliases:proga
Position:Named
Default value:None
Required:False
Accept pipeline input:False
Accept wildcard characters:False

-ServerInstance

Specifies the name of a Business Central Server instance, for example, BC or myinstance. You can specify either the full name of an instance, such as MicrosoftDynamicsNavServer$myinstance or the short name such as myinstance.

Type:String
Position:0
Default value:None
Required:True
Accept pipeline input:True
Accept wildcard characters:False

-Tenant

Specifies the ID of the tenant that you want to check schema for, such as Tenant1.

This parameter is required unless the specified service instance is not configured to run multiple tenants.

Type:TenantId
Aliases:Id
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

Inputs

System.String

By value and by property name: ServerInstance

Microsoft.Dynamics.Nav.Types.TenantId

By property name: Tenant