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