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]
[-ProgressAction <ActionPreference>]
[-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 'Business Central 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, Business Central 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 |
Required: | False |
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 |
Required: | False |
Accept pipeline input: | True |
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 |
Required: | True |
Accept pipeline input: | True |
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 |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Force
Forces the command to run without asking for user confirmation.
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
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 |
-WhatIf
Describes what would happen if you executed the command without actually executing the command.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
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.