Remove-NAVApplication

Removes the tables that define the application from a Business Central database. When you have removed the application tables from the database, you cannot import them again. Make sure that you have a full backup available.

Syntax

Remove-NAVApplication
      [-DatabaseServer <DatabaseServer>]
      [-DatabaseInstance <DatabaseInstance>]
      -DatabaseName <DatabaseName>
      [-Force]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

Use the Remove-NAVApplication cmdlet to delete the application tables from the specified Business Central database. Use this cmdlet after you have extracted the application tables to a new application database by using the Export-NAVApplication cmdlet. For example, if you are upgrading to the current version of Business Central, you can use the Export-NAVApplication cmdlet and the Remove-NAVApplication cmdlet during the upgrade. Also, if you migrate to a multitenant deployment architecture, you can use the Export-NAVApplication cmdlet and the Remove-NAVApplication cmdlet when you set up the application and tenant databases.

Examples

EXAMPLE 1

Remove-NAVApplication -DatabaseName 'Demo Database NAV'

This example removes the application tables from the specified database on the local server.

EXAMPLE 2

Remove-NAVApplication -DatabaseServer 'MyServer' -DatabaseInstance 'NAVDemo' -DatabaseName 'Demo Database NAV'

This example shows how to remove the application-wide tables from the demonstration database on the specified server and instance.

EXAMPLE 3

Export-NAVApplication -DatabaseServer 'MyServer' -DatabaseInstance 'NAVDEMO' -DatabaseName 'Demo Database NAV' -DestinationDatabaseName 'NAV App'| Remove-NAVApplication -DatabaseName 'Demo Database NAV' -Force

This example shows how you can combine the Export-NAVApplication cmdlet and the Remove-NAVApplication cmdlet when you set up the application and tenant databases. The example extracts the application tables to a new database, NAV App, and then removes the tables from the original database. Next, you mount the two databases against a Business Central Server instance by using the Mount-NAVApplication cmdlet and the Mount-NAVTenant cmdlet.

Parameters

-Confirm

Prompts you for confirmation before executing the command.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseInstance

Specifies the name of the SQL Server instance where the Business Central database is located. The default value is MSSQLSERVER.

Type:DatabaseInstance
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-DatabaseName

Specifies the name of the database that the application tables must be removed from.

Type:DatabaseName
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-DatabaseServer

Specifies the name of the computer that is running SQL Server. The default value is localhost.

Type:DatabaseServer
Position:Named
Default value:None
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False
-Force

Forces the command to run without asking for user confirmation.

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

Describes what would happen if you executed the command without actually executing the command.

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

Outputs

System.String ServerName

Returns the value of the DatabaseServer parameter.

System.String ServerInstance

Returns the value of the DatabaseInstance parameter.

System.String DatabaseName

Returns the value of the DatabaseName parameter.