Invoke-NAVApplicationDatabaseConversion
Performs a technical upgrade of a database from a previous version of Business Central.
Syntax
Invoke-NAVApplicationDatabaseConversion
[-DatabaseServer <String>]
-DatabaseName <String>
[-ApplicationDatabaseCredentials <PSCredential>]
[-Force]
[-ProgressAction <ActionPreference>]
[-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
Type: | PSCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
Type: | SwitchParameter |
Aliases: | cf |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DatabaseName
Specifies the name of the database that you want to convert.
Type: | String |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | 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.
Type: | String |
Position: | Named |
Default value: | Localhost |
Required: | False |
Accept pipeline input: | True |
Accept wildcard characters: | 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.
Type: | SwitchParameter |
Position: | Named |
Default value: | False |
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
Shows what would happen if the cmdlet runs. The cmdlet is not run.
Type: | SwitchParameter |
Aliases: | wi |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
Inputs
System.String
By property name: DatabaseServer
System.String
By property name: DatabaseName
System.Management.Automation.PSCredential
By property name: ApplicationDatabaseCredentials