Invoke-NAVApplicationDatabaseConversion
Performs a technical upgrade of a database from a previous version of Business Central.
Syntax
Default (Default)
Invoke-NAVApplicationDatabaseConversion
[-DatabaseServer <String>]
-DatabaseName <String>
[-ApplicationDatabaseCredentials <PSCredential>]
[-Force]
[-WhatIf]
[-Confirm]
[<CommonParameters>]
Description
This cmdlet converts a database from a previous Business Central platform version to the current version that you are running. The conversion updates the system tables of the database to the new schema (data structure) and provides the latest platform features and performance enhancements.
By default, you'll have to uninstall all extensions before you can run this cmdlet. You can use the -Force parameter to run the cmdlet without uninstalling extensions, but this is only recommended for multitenant deployments.
Examples
EXAMPLE 1
Invoke-NAVApplicationDatabaseConversion -DatabaseName MyApp
Performs a technical upgrade on a database named MyApp.
EXAMPLE 2
Invoke-NAVApplicationDatabaseConversion -DatabaseName MyApp -DatabaseServer "TestComputer01\NAVDEMO"
Performs a technical upgrade on a database named MyApp that is on an SQL server named TestComputer01\NAVDEMO.
Parameters
-ApplicationDatabaseCredentials
Specifies a username and password of a login account that has access to the database. If you omit this parameter, then the cmdlet uses the credentials of the current Windows user to authenticate to the database. The login account must be a member of the db_owner role on the database
Parameter properties
| Type: | PSCredential |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | cf |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-DatabaseName
Specifies the name of the database that you want to convert.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-DatabaseServer
Specifies the name of the computer and SQL Server instance that hosts the database that you want to convert. The value has the format ComputerName\SQLServerInstance.
Parameter properties
| Type: | String |
| Default value: | Localhost |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-Force
This parameter let's you run the cmdlet even if there are installed extensions. Use this parameter to convert the application database in a multitenant deployment server instance. Forces the command to run without asking for user confirmation.
Parameter properties
| Type: | SwitchParameter |
| Default value: | False |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-WhatIf
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | wi |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Inputs
System.String
By property name: DatabaseServer
System.String
By property name: DatabaseName
System.Management.Automation.PSCredential
By property name: ApplicationDatabaseCredentials