Remove-NAVAppsForTenant

Removes all NAV Apps from the specified, unmounted tenant. This cmdlet should be run against tenants that are not mounted.

Syntax

Remove-NAVAppsForTenant
      [-DatabaseServer <String>]
      [-DatabaseName <String>]
      [-DatabaseCredentials <PSCredential>]
      [-ApplicationDatabaseServer <String>]
      [-ApplicationDatabaseName <String>]
      [-ApplicationDatabaseCredentials <PSCredential>]
      [-DoNotSaveData]
      [-Force]
      [<CommonParameters>]

Description

Use the Remove-NAVAppsForTenant cmdlet to remove all NAV Apps from a tenant database that cannot be mounted due to metadata conflicts. This cmdlet should be run against tenants that are not mounted. This may change the database schema so you must specify if you do not want to save data, otherwise if will be saved.

Examples

EXAMPLE 1

Remove-NAVAppsForTenant -ApplicationDatabaseName 'Demo Database NAV' -ApplicationDatabaseServer NAVSQLServer -DatabaseName Tenant1 -DatabaseServer NAVSQLServer

This example uninstalls all of the NAV Apps in the unmounted tenant database with the name of Tenant1. If the NAV App contains a schema change, the tenant database will be synchronized and the data will be saved.

EXAMPLE 2

Remove-NAVAppsForTenant -ApplicationDatabaseName 'Demo Database NAV)' -ApplicationDatabaseServer NAVSQLServer -DatabaseName Tenant1 -DatabaseServer NAVSQLServer -DoNotSaveData

This example uninstalls all of the NAV Apps in the unmounted tenant database with the name of Tenant1. If the NAV App contains a schema change, the tenant database will be synchronized and the data will not be saved since the -DoNotSaveData parameter switch was provided.

Parameters

-ApplicationDatabaseCredentials

Specifies the user name and password of a SQL Server Authentication login account that provides access to the Microsoft Dynamics NAV application database in SQL Server.

You use this parameter to access the database by using SQL Server Authentication. If you want to use Windows Authentication, then you can omit this parameter.

The login account must be a member of the db_owner role on the database.

Type:PSCredential
Position:Named
Default value:None
Required:False
Accept pipeline input:True
Accept wildcard characters:False

-ApplicationDatabaseName

Specifies the name of the Microsoft Dynamics NAV database that contains the application tables in the multitenant deployment.

You must also set the ApplicationDatabaseServer parameter.

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

-ApplicationDatabaseServer

Specifies the name of the computer on which the SQL Server instance for the Microsoft Dynamics NAV database that contains the application tables is installed in the multitenant deployment. The default value is "." for the current machine.

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

-DatabaseCredentials

Specifies the user name and password for a SQL Server Authentication login account that provides access to the database or tenant database (in a multitenant deployment) in SQL Server.

You use this parameter to access the database by using SQL Server Authentication. If you want to use Windows Authentication, then you can omit this parameter.

The login account must be a member of the db_owner role on the database.

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

-DatabaseName

Specifies the name of the Microsoft Dynamics NAV database, such as 'Demo Database NAV', that stores the business data.

In a multitenant deployment, this is the name of the tenant database.

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

-DatabaseServer

Specifies the name of the computer on which the SQL Server instance for the Microsoft Dynamics NAV database is installed. The default value is "." for the current machine.

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

-DoNotSaveData

Specifies that you do not want to copy data to an archive table if the removal of a NAV App changes the database schema. if you set this parameter, the data will not be archived and you will not be able to restore it if you need to reinstall the NAV App.

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

-Force

Forces the command to run without asking for user confirmation about the tenant that you are removing NAV Apps from.

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