Export-NAVApplication
Extracts the application tables in a Business Central database to a separate database. The new application database is created on the same SQL Server instance as the original database.
Syntax
Export-NAVApplication
[-DatabaseServer <DatabaseServer>]
[-DatabaseInstance <DatabaseInstance>]
-DatabaseName <DatabaseName>
-DestinationDatabaseName <DatabaseName>
[-ServiceAccount <String>]
[-Force]
[-ProgressAction <ActionPreference>]
[-WhatIf]
[-Confirm]
[<CommonParameters>]Description
Use the Export-NAVApplication cmdlet to export the tables that define the Business Central application to a dedicated database. If you want to deploy your Business Central solution in a multitenant deployment architecture, you must separate the application tables in an existing database into two databases: an application database and a business data database. You can combine the Export-NAVApplication cmdlet with the Remove-NAVApplication cmdlet. Before you use the Export-NAVApplication cmdlet, we recommend that you create a full backup of your existing database.
Examples
EXAMPLE 1
Export-NAVApplication -DatabaseName 'Demo Database NAV' -DestinationDatabaseName NAVAppThis example extracts the application tables from the specified database to a new application database on the local server.
EXAMPLE 2
Export-NAVApplication -DatabaseName 'Demo Database NAV' -DestinationDatabaseName NAVApp -ServiceAccount 'mydomain\navdbaccount'This example extracts the application tables from the specified database to a new application database on the local server.
EXAMPLE 3
Export-NAVApplication -DatabaseServer 'MyServer' -DatabaseInstance 'NavDemo' -DatabaseName 'Demo Database NAV' -DestinationDatabaseName 'Business Central app'This example extracts the application tables from the specified database to a new application database on the specified server and instance.
EXAMPLE 4
Export-NAVApplication -DatabaseServer 'MyServer' -DatabaseInstance 'NavDemo' -DatabaseName 'Demo Database NAV' -DestinationDatabaseName 'Business Central app' | Remove-NAVApplication -ForceThis example extracts the application tables from the specified database to a new application database on the specified server and instance. It then pipes the name of the database to the Remove-NAVApplication cmdlet, which removes the application tables from the original database.
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 SQL Server instance on which the Business Central database is installed. The new application database will be created on the same SQL Server instance as the original database.
| Type: | DatabaseInstance |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-DatabaseName
Specifies the name of the Business Central database that contains the application tables, such as 'Demo Database NAV (11-0)'. This database is the original database that application tables will be extracted 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 on which the SQL Server instance for the Business Central database is installed.
| Type: | DatabaseServer |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-DestinationDatabaseName
Specifies the name of the database that you want to export the tables to. If a database with that name does not exist, a new database is created on the same SQL Server instance as the original database.
| Type: | DatabaseName |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| 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 |
-ServiceAccount
The account that Business Central Server uses to access SQL Server. The database roles that the account has will be copied from the original database to the new application database. If this parameter is not specified, the Export-NAVApplication cmdlet will use the NT AUTHORITY\NETWORK SERVICE account.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | True |
| 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
The value of the DatabaseServer parameter.
System.String ServerInstance
The value of the ServerInstance parameter.
System.String DatabaseName
The value of the DatabaseName parameter.